Excel Formula w/ Time format

T

tanya

I am trying to create a time sheet with in and out columns. The in / out
columns are formatted as time. The "total" column needs to be the total
number of hours - I am unable to get the arithmetic to work. Thankyou.
 
D

Dave F

If In = 8:00 AM and Out = 5:00 PM, then (5:00 PM - 8:00 AM) * 24 will yield 9
hours.

The reason being is that Excel stores time as fractions of a day. The
calculation above is really (17/24 - 8/24) * 24 = 9/24 * 24/1 = 9 hours.

Make sure the cell in which you are performing the calculation is formatted
as numbers, not time.
 
Y

yamahapm1d

If the first 'IN' is in cell A1 and the first 'OUT' is in cell B1, the second
'IN' is in cell C1 and the second 'OUT' is in cell D1 where the total hours
will be in cell E1, try the following.

IN CELL E1
=(B1-A1)+E1-D1

make sure your 'IN' and 'OUT' cells are formatted for time.
enter your time for AM as #:## and for PM as #:## pm (don't forget the space
between the last number and the pm
 
Top