Formula for time?
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"shaggy78" schrieb im Newsbeitrag
...
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....

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

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

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


"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany
"shaggy78" schrieb im Newsbeitrag
...
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....

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

"Ted Metro" wrote:

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

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

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

"Ted Metro" wrote:

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

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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"shaggy78" schrieb im Newsbeitrag
...
=TEXT(G25-F25,"h:mm") this is the formula I am working with... Thanks
again.

"Ted Metro" wrote:

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

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

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

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

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.

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

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany
"shaggy78" schrieb im Newsbeitrag
...
=TEXT(G25-F25,"h:mm") this is the formula I am working with... Thanks
again.

"Ted Metro" wrote:

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

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