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.
--
Brevity is the soul of wit.


"tanya" wrote:

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.