Subtracting times..confused

T

Tim

Quick question:
How do I properly enter times to produce a "correct" result?
For example, trying to figure out the hours worked by various employees.
Finish time - start time
For example, 11 Am -8 am results in 3 AM, I want this to result in 3 hours.
Is this a formatting issue?
Any assistance would be appreciated.
Thanks in advance.
Tim
 
A

a_d66

hey Tim,
you can change the format of the cell to just an hour with out the AM
or PM.
so - 8 AM - 5 AM will give you just 3:00
 
D

David

You need to do calculations. 11:30 am to 6:00 pm = 6.5 hrs.
If 11:30am is in A1 and 6:00pm is in B1 the formula would be:
(hour(b1)+(minute(b1)/60))-(hour(a1)+minute(a1)/60))
results in (18+0)-(11+.5) or 6.5
If the times could possibly overlap different days (11pm - 7am):
IFb1>=a1,(hour(b1)+12+(minute(b1)/60))-(hour(a1)+minute(a1)/60)),(hour(b1)+(minute(b1)/60))-(hour(a1)+minute(a1)/60))
 
Top