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