Hi Chen,
Thank you very much! I have been looking for that formula I while ago. I
tried and it helped. Thanks!

"Daniel CHEN" wrote:

=(B1-A1)*24+24*IF(B1A1,0,1)

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================
"Ron" wrote in message
...
I've have the same thing. I have built a spreedsheet to kept track of my
hours worked. I go in at 21:45 each nite and get off at 06:00. I can not
get
the spreedsheet to total the hours. Every outher week I have to work
over, I
go in
at 21:45, but I don't get off until 14:00 the next day, for a total of
16:15. I NEED
HELP WITH THIS ONE PLEASE.
--
ironmn


"Andrew" wrote:

I have created a formula for calculating total hours / day
the times are entered in military time
a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I can
not get those numbers in the C colum to add up for a rolling total

HELP !!!!!