Formula for time?

[Guest]

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

 

[Frank Kabel]

Hi
maybe check out:
http://www.cpearson.com/excel/overtime.htm

 

[Guest]

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

 

[Guest]

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

 

[Guest]

=TEXT(G25-F25,"h:mm") this is the formula I am working with... Thanks again.

 

[Guest]

=TEXT(G25-F25,"h:mm") this is the formula. thank you for your help...

 

[Guest]

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

 

[Frank Kabel]

Hi
try
=(G25-F25)*24
and format as number (not as time)

 

[Guest]

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.

 

[Bob Phillips]

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

--

HTH

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

 

[Guest]

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.

 

[Guest]

Thank you for your help, I got everything working. Thanks everyone.