=MOD(B1-A1,1)*24 ?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"shaggy78" wrote in message
...
Ok, I tried it and it worked, thank you, now for my next problem, I need
to
come with a total time worked in decimal format, if the driver came in at
8:00am and worked until 2:30pm how would I do that. Thank you for all your
help also.

"Ted Metro" wrote:

Shaggy assuming your clock in times are a1 through a4 and your time of
run is
b1 through b4 enter this formula in column c --

=(b1-a1)*1440

Make sure the cell is formatted as a number (not a time) and if they
come in
early it should be a positive number, and if they come in late it should
be a
negative number, displayed in minutes.

if the person came in early

"shaggy78" wrote:

I am trying to create a spreadsheet that calculates difference in
times.
however if I have someone come in early it says in the box ###Num###.
Ex..
Clocked In Time of Run
7:54 8:00
8.:03 8:00
7:52 8:00
8:06 8:00

I need to run the same formula if there is overtime or if they are
late. Can
someone help me please......

Thanks....