Totaling Hours Worked

[Debra Ann]

I have one column that has my start time (6:30 AM) and one
column that has my end time (3:30 PM). How do I make the
third column total the hours I worked (9.00)?

Thanks for any help.

Debra Ann

 

[George Nicholson]

(EndTime - StartTime)* 24

To Excel, a day = 1 and an hour = 1/24 so, to convert an hour value "up" to
an integer, multiply by 24.

Hope this helps,

 

[Andy Brown]

How do I make the

third column total the hours I worked (9.00)?

Use a formula along the lines of

=B1-A1

, unless your times are likely to span midnight, in which case

=B1-A1+(A1>B1)

Rgds,
Andy

 

[Guest]

Debra Ann,
Assuming your start time is in A1 and your end time is in B1 then enter this formula in C1:

=B1-A1

then apply the custom number format of [h]:mm. This will prevent the time worked from rolling over like a clock at 12:00.

Good Luck,
Mark Graeser
(e-mail address removed)

----- Debra Ann wrote: -----

I have one column that has my start time (6:30 AM) and one
column that has my end time (3:30 PM). How do I make the
third column total the hours I worked (9.00)?

Thanks for any help.

Debra Ann

 

[martialtiger]

Is there anyway to have 2 different formulas used. 1 if you work unde
6 hours. And the other if you work over 6 hours to include lunch

 

[Frank Kabel]

You can use the IF formula
=IF(B1-A1<=(6/24),B1-A1,B1-A1+lunch)
Frank

 

[martialtiger]

Thanks... I tried it and for the most part it worked. Here's the
problem I'm getting though.

Here's the values I have in the following cells:
B12=13:00 C12=18:00 and B13 the formula is

=IF(B12="","OFF",IF(C12-B12<=(6/24),C12-B12,(C12-B12)-"00:30")). It spits out the correct amt: 5:00. Now in the next 2 cells D12=8:30

and E12=14:00. D13 has the same formula as above, but it is spitting
out a value of 5:30.

I've been trying to figure it out....

 

[martialtiger]

Thanks for the help... worked great!