Totaling Hours Worked

D

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
 
G

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,
 
A

Andy Brown

How do I make the
third column total the hours I worked (9.00)?
Click to expand...

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
 
M

Mark Graesser

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
[email protected]

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

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
 
M

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
Click to expand...
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.... :confused:
 
Top