Formula used to calculate daily employment hours ...

G

Guest

Excel version 2003...I need to calculate overtime hours....how do you
differentiate between AM PM....how do you caluculate when hours run from one
day to the next
ex. 11:00pm - 2:00Am the following day
 
B

Biff

Hi!

A1 = 11:00 PM
B1 = 2:00 AM

If you want the returned value displayed like - 3:00 - format the cell as
h:mm and use this formula:

=B1-A1+(B1<A1)

If you want the returned value displayed as a decimal - 3 - then use this
formula:

=(B1-A1+(B1<A1))*24
...I need to calculate overtime hours....
Click to expand...

Need more details.

Biff
 

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

Calculate After hours 3
Calculate hours and minutes between times when it goes past midnig 9
Trying to calculate hours worked on timecard using "IF" command 6
Converting time to decimal 4
calculate hours 3
Timesheet formula problem 2
calculate difference in time to hours 4
over time in a sheet 2

Top