Please help Bob!!!!

[Guest]

Hi Bob please help!!!!! it did not work.This is a example of what I want to do

Date In Out Lunch
Total Hours over time
Friday 10/1/2004 8:11 16:37 00:30:00 8:25
How do I
Saturday 10/2/2004 0:00
get this
Sunday 10/3/2004 11:57 15:03 00:00:00 3:06
awnser
Monday 10/4/2004 7:55 17:01 00:30:00 9:05
Tuesday 10/5/2004 7:36 16:25 00:30:00 8:48
Total:
How do I get this awnser
=SUM(D3-C3-E3/1440) This is the formula that I used to calculate total hours
how do I ad them up

 

[Biff]

Hi!

Your totals where there are times deducted for lunch are
incorrect.

=SUM(D3-C3-E3/1440) This is the formula that I used

Since the time entered for lunch is a true Excel time you
DON'T need to divide by 1440. You only need to do that to
convert the decimal number of minutes into a decimal part
of a day.

All you need to do is:

=D3-C3-E3

And to get the total for the week:

=SUM(daily total range)

Format as [hh]:mm

Biff

 

[Bob Phillips]

AS I said, because you divided by 1440 I assumed that lunch was decimal
minutes. I can see it is time now, so try

=SUM(D310)-SUM(C3:C10)-SUM(E3:E10)

--

HTH

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

 

[Guest]

Hi Biff
Thank you for the reply.

I am realy in a spin now!
Look at the folowing, can you do somthing to help me so that the times that
it works out is correct??
Example:
Date Time in Time out Lunch Total Hours Over time
10/1/2004 8:11 16.37 00:00:30 ????? ?????
11/1/2004 8:00 17.37 00:00:35
12/1/2004 7:11 18.21 00:01:30
13/1/2004 8:20 16.10 00:00:30
14/1/2004 6:11 16.35 00:00:20
15/1/2004 8:31 16.55 00:00:30
16/1/2004 8:21 19.37 00:00:30
Total:?????? ??????
What Formulas must I put in I have tried >=SUM(D3-C3-E3/1440) & =D3-C3-E3
but I get deffrent awnsers and then I get ##### for over time hours.
Please help if you can!!
Regards
darkct (Chris)

Hi!

Your totals where there are times deducted for lunch are
incorrect.

=SUM(D3-C3-E3/1440) This is the formula that I used

Since the time entered for lunch is a true Excel time you
DON'T need to divide by 1440. You only need to do that to
convert the decimal number of minutes into a decimal part
of a day.

All you need to do is:

=D3-C3-E3

And to get the total for the week:

=SUM(daily total range)

Format as [hh]:mm

Biff

-----Original Message-----
Hi Bob please help!!!!! it did not work.This is a example of what I want to do

Date In Out Lunch
Total Hours over time
Friday 10/1/2004 8:11 16:37 00:30:00 8:25
How do I
Saturday 10/2/2004 0:00
get this
Sunday 10/3/2004 11:57 15:03 00:00:00 3:06
awnser
Monday 10/4/2004 7:55 17:01 00:30:00 9:05
Tuesday 10/5/2004 7:36 16:25 00:30:00 8:48
Total:
How do I get this awnser
=SUM(D3-C3-E3/1440) This is the formula that I used to calculate total hours
how do I ad them up

.

 

[Guest]

Day Date In Out Lunch Total Hours Over Time

Monday 10/25/2004 7:16 19:17 00:30:00 ???? ?????
Tuesday 10/26/2004 7:02 19:17 00:30:00
Wednes 10/27/2004 7:11 19:20 00:30:00
Thursday 10/28/2004 7:00 19:09 00:30:00
Friday 10/29/2004 7:11 13:44 00:00:00
Saturday 10/30/2004 7:29 19:12 00:30:00
Sunday 10/31/2004 7:12 18:55 00:30:00
Total weekly hours ??? ??? ??? ??????? ??????
Oct. total: Regular hours & Over time hours ????? ???? ??? ???

Hi!

Your totals where there are times deducted for lunch are
incorrect.

=SUM(D3-C3-E3/1440) This is the formula that I used

Since the time entered for lunch is a true Excel time you
DON'T need to divide by 1440. You only need to do that to
convert the decimal number of minutes into a decimal part
of a day.

All you need to do is:

=D3-C3-E3

And to get the total for the week:

=SUM(daily total range)

Format as [hh]:mm

Biff

-----Original Message-----
Hi Bob please help!!!!! it did not work.This is a example of what I want to do

Date In Out Lunch
Total Hours over time
Friday 10/1/2004 8:11 16:37 00:30:00 8:25
How do I
Saturday 10/2/2004 0:00
get this
Sunday 10/3/2004 11:57 15:03 00:00:00 3:06
awnser
Monday 10/4/2004 7:55 17:01 00:30:00 9:05
Tuesday 10/5/2004 7:36 16:25 00:30:00 8:48
Total:
How do I get this awnser
=SUM(D3-C3-E3/1440) This is the formula that I used to calculate total hours
how do I ad them up

.

 

[Biff]

Hi!

To get the DAILY total:

=Time out minus time in minus lunch

=D3-C3-E3

Overtime?

How is overtime calculated? All hours over 8?

=IF(F3>8/24,F3-8/24,0)

Total hours worked for the week with total DAILY hours in
F3:F8:

=SUM(F3:F8)

Biff

-----Original Message-----
Hi Biff
Thank you for the reply.

I am realy in a spin now!
Look at the folowing, can you do somthing to help me so that the times that
it works out is correct??
Example:
Date Time in Time out Lunch Total Hours Over time
10/1/2004 8:11 16.37 00:00:30 ????? ?????
11/1/2004 8:00 17.37 00:00:35
12/1/2004 7:11 18.21 00:01:30
13/1/2004 8:20 16.10 00:00:30
14/1/2004 6:11 16.35 00:00:20
15/1/2004 8:31 16.55 00:00:30
16/1/2004 8:21 19.37 00:00:30
Total:?????? ??????
What Formulas must I put in I have tried >=SUM(D3-C3- E3/1440) & =D3-C3-E3
but I get deffrent awnsers and then I get ##### for over time hours.
Please help if you can!!
Regards
darkct (Chris)

Hi!

Your totals where there are times deducted for lunch are
incorrect.

=SUM(D3-C3-E3/1440) This is the formula that I used

Since the time entered for lunch is a true Excel time you
DON'T need to divide by 1440. You only need to do that to
convert the decimal number of minutes into a decimal part
of a day.

All you need to do is:

=D3-C3-E3

And to get the total for the week:

=SUM(daily total range)

Format as [hh]:mm

Biff

-----Original Message-----
Hi Bob please help!!!!! it did not work.This is a

example
of what I want to do

Date In Out Lunch
Total Hours over time
Friday 10/1/2004 8:11 16:37 00:30:00 8:25
How do I
Saturday 10/2/2004 0:00
get this
Sunday 10/3/2004 11:57 15:03 00:00:00 3:06
awnser
Monday 10/4/2004 7:55 17:01 00:30:00 9:05
Tuesday 10/5/2004 7:36 16:25

00:30:00 8:48

Total:
How do I get this awnser
=SUM(D3-C3-E3/1440) This is the formula that I used to calculate total hours
how do I ad them up

.

.