Skip to Content
0
Former Member
Dec 02, 2008 at 09:33 AM

Business Hours

35 Views

Hi All,

I am having a problem calculating business hours.

I have found/written formulas that can create the amount of business hours fine as a decimal but not as time (hh.mm).

For example, 7.75 should be 7.45 & 6.5 should be 6.30 etc

I did find a formula that did this but came up with an error for any number over 24!

Please coould someone advice me off the best way to convert a decimal number to a time that will allow over 24.

I do not want it showing days. Only hours and minutes.

Thanks,

Scott