I need a formula that will calculate the total time in Whole Hours & Percent of Hour.



It also needs to calculate over Midnight - 20:00 hrs to 01:30 hrs which should equal 5.5 hrs total time.

I have read through some similar issues but cannot find anything to covers the over midnight part.

I am using Office 2008 for MAC.

Thanks in advance.

The over midnight calculation can be obtained using =MOD(end_time-start_time,1)

Astonishing as this is a well known problem

What do you mean by "Whole hours and % of an hour". What should the result look like?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

So if the time on site is equal to 5 hours and 30 minutes, the answer I am needing is 5.5 hours or 3 hours and 15 minutes would be 3.25 hours.

Thanks.

Also forgot to add that the time format is in 24 hrs using 0":"00

To change sexagesimal to decimal, multiply by 24 and format as number

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

An alternative to what has already been mentioned is to use (in C1):

=((B1<A1)+B1-A1)*24

where A1 holds start_time and B1 end_time, and where C1 is formatted General.

Xor, I like your unpersonalized approach....

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post