Time as a Fraction of a Day

Excel stores a date as a whole number and a time as the fractional part of a day (midday is 0.5, 6 am is 0.25), so times can be added, subtracted and compared. Multiply a difference by 24 to get hours.

When to use

Forgetting the *24 is a classic mistake: comparing a time difference such as 0.375 with 8 is always true. In the timesheet, hours worked are (Stop-Start)*24.

See Lec 05.

Appears in

No references yet.