Roger, I would like to email you my time sheet so you can see if you can
help. I need your email address or a place where I can send this. Ron
(IRONMN)
--
ironmn


"Roger Govier" wrote:

Hi Ron

With clock on in A1 and clock off in B1 try
=MOD(B1-A1,1)

--
Regards

Roger Govier


"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 !!!!!