Formula for time?

S

shaggy78

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....
 
T

Ted Metro

Can you post the formula you're using, and the formula that's creating the
error? That sounds like an easy fix...
 
S

shaggy78

Thank you for the spreadsheet but unfortunately the way work has the
spreadsheet setup it is not working. If I have a driver due in at 8:00am and
he comes in at 8:02 how would I be able to calculate the difference in a
decimal format, using I guess a negative to show that they were late or
early, also I need to be able to clock there total time worked in a decimal
format. Ex... 8:30am to 2:30 pm... can you please help sorry.... This is very
stressful figuring this out...
 
T

Ted Metro

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
 
S

shaggy78

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.
 
B

Bob Phillips

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

--

HTH

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

Ted Metro

So if 'clock in' was 8:00 and 'clock out' was 2:30 you want excel to = 6.5?

in a1 enter 8:00 am
in b1 enter 2:30 pm

in c1 enter =(b1-a1)*24

c1 has to be formatted as a number.
 
Top