Got a question... I'm using this formula to calculate time (overtime)

=(D4-B4+(D4<B4))*24

B4 is my starting time, D4 is my ending time. For the most part, this
works pretty
good unless I work a full 24hr shift. If my shift starts at 07:00, ends
24hrs later at 07:00, this formula gives me a value of 0. How can I make
this show 24hrs?

I'm using a form in excel, there's no room to format the cell using
date & time,
(there's another cell that lists the date) it needs to read the time
only. Once these forms are filled out, they are printed and submitted
with our time sheets.

Any suggestions???


JF


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=477255