Timecards

[Retsailor]

I am trying to work a timecard that figures time for someone that works over
night. The following formula only seems to work for the day shift.

=IF(E10-D10+G10-F10<=0,0,E10-D10+G10-F10)

I need this to know that 8 hours is the normal and anything ove 8 is
overtime. Any help will be greatly appreciated.

 

[JoAnn Paules]

Try changing your time to a serial number. (Not sure if that works but it's
worth a shot)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

 

[Retsailor]

Thanks for the info but a coworker showed me the following formula and it
seems to work.

=IF(E10<D10,E10+1-D10,E10-D10)+IF(G10<F10,G10+1-G10,G10-F10)
All I have to do is change the cell for each line.

Try changing your time to a serial number. (Not sure if that works but it's
worth a shot)

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

I am trying to work a timecard that figures time for someone that works
over
night. The following formula only seems to work for the day shift.

=IF(E10-D10+G10-F10<=0,0,E10-D10+G10-F10)

I need this to know that 8 hours is the normal and anything ove 8 is
overtime. Any help will be greatly appreciated.