Hi,
Very often, in time registration, decimals are used to indicate hours.
e.g. 1.5 instead of 1:30
This is in fact incorrect. Excel translates 1.5 into a date.
1.5 is in fact 1.5 days after 01-Jan-1900.
When you apply a date format to a cell containing 2, this would return 02-Jan-1990
Back to the problem. How Can we convert decimal numbers [...]
Excel has two date systems, but is defaulted to the 1900 Date system. This system however can not handle negative hours.
1900 Date system
In the 1900 date system, the first day that is supported is January 1, 1900. When you enter a date, the date is converted into a serial number that represents the number of [...]
In this example we will add times. The result will be greater than 24:00 hours.
By default, Excel displays 24:00 as 12:00, 28:00 as 04:00
In the above example, the actual hours worked would be 38. However, the format being used does not allow Excel to display elapsed hours.
Instead Excel displays the result of the subtraction 38:00-24:00.
How [...]