Formula used to calculate daily employment hours ...

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

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....

Need more details.

Biff

"DarDarren" <DarDarren@discussions.microsoft.com> wrote in message
news:206472B9-14B9-4B0C-8529-362165A4AB41@microsoft.com...
> 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