Help please time?

[Guest]

Hi can someone help me I used the following formula
=SUM(D3-C3-E3/1440)
it works to take time in time out and lunch and get total working hours.
But now I want to ad say the weeks total hours together to get a grand total
of hours work for the week. How do I had it up

 

[Bob Phillips]

I presume that C and D hold time, and E holds a decimal number of minutes.
Assuming so, use

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

and make sure the target cell is formatted as [h]:mm

--

HTH

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

 

[Guest]

Thank you Bob

I presume that C and D hold time, and E holds a decimal number of minutes.
Assuming so, use

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

and make sure the target cell is formatted as [h]:mm

--

HTH

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

Hi can someone help me I used the following formula
=SUM(D3-C3-E3/1440)
it works to take time in time out and lunch and get total working hours.
But now I want to ad say the weeks total hours together to get a grand total
of hours work for the week. How do I had it up

 

[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
Friday 10/1/2004 8:11 16:37 00:30:00 8:25
Saturday 10/2/2004 0:00
Sunday 10/3/2004 11:57 15:03 00:00:00 3:06
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

I presume that C and D hold time, and E holds a decimal number of minutes.
Assuming so, use

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

and make sure the target cell is formatted as [h]:mm

--

HTH

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

Hi can someone help me I used the following formula
=SUM(D3-C3-E3/1440)
it works to take time in time out and lunch and get total working hours.
But now I want to ad say the weeks total hours together to get a grand total
of hours work for the week. How do I had it up

 

[Bob Phillips]

Can you explain what is in what column, what you expect to get etc. as that
data sample does transcribe well?

--

HTH

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

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

Date In Out Lunch Total Hours
Friday 10/1/2004 8:11 16:37 00:30:00 8:25
Saturday 10/2/2004 0:00
Sunday 10/3/2004 11:57 15:03 00:00:00 3:06
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

I presume that C and D hold time, and E holds a decimal number of minutes.
Assuming so, use

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

and make sure the target cell is formatted as [h]:mm

--

HTH

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

Hi can someone help me I used the following formula
=SUM(D3-C3-E3/1440)
it works to take time in time out and lunch and get total working hours.
But now I want to ad say the weeks total hours together to get a grand total
of hours work for the week. How do I had it up

 

[Guest]

Yes can I e-mail you a example.What is your E-mail address so that I can sent
a attacment of the file.Do not worry no viruses.

Can you explain what is in what column, what you expect to get etc. as that
data sample does transcribe well?

--

HTH

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

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

Date In Out Lunch Total Hours
Friday 10/1/2004 8:11 16:37 00:30:00 8:25
Saturday 10/2/2004 0:00
Sunday 10/3/2004 11:57 15:03 00:00:00 3:06
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

I presume that C and D hold time, and E holds a decimal number of minutes.
Assuming so, use

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

and make sure the target cell is formatted as [h]:mm

--

HTH

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


Hi can someone help me I used the following formula
=SUM(D3-C3-E3/1440)
it works to take time in time out and lunch and get total working hours.
But now I want to ad say the weeks total hours together to get a grand
total
of hours work for the week. How do I had it up

 

[Bob Phillips]

if my response in your other thread did not help, send it to me at
bob dot phillips at tiscali dot co dot uk

no spaces and change the link words dot and at

And I will check for viruses anyway

bob

Yes can I e-mail you a example.What is your E-mail address so that I can sent
a attacment of the file.Do not worry no viruses.

Can you explain what is in what column, what you expect to get etc. as that
data sample does transcribe well?

--

HTH

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

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

want
to do

Date In Out Lunch Total Hours
Friday 10/1/2004 8:11 16:37 00:30:00 8:25
Saturday 10/2/2004 0:00
Sunday 10/3/2004 11:57 15:03 00:00:00 3:06
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


:

I presume that C and D hold time, and E holds a decimal number of minutes.
Assuming so, use

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

and make sure the target cell is formatted as [h]:mm

--

HTH

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


Hi can someone help me I used the following formula
=SUM(D3-C3-E3/1440)
it works to take time in time out and lunch and get total working hours.
But now I want to ad say the weeks total hours together to get a grand
total
of hours work for the week. How do I had it up