Subtracting times..confused

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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))
 
Back
Top