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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if night shift by start & end time 2
subtract times with a negative result 1
How do I subtract 8 business hours from a date/time value? 5
How to calculate Premium Time 2
time sheet and majority hours 8
Totally confused by SUMIF 3
Find time difference and display it in hours 1
Subtract 12 hours from date/time 6

Back
Top