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