To convert a number, follow these steps:
- Use the following formula to convert the number to a serial number
=n/24
where n is any decimal number representing hours.
- On the Format menu, click Cells, and then click the Number tab.
- Under Category, select Time; under Type, select the number format that you want.
NOTE: You can also use this procedure to convert time values to decimal values. To do this, start from a time value, convert it to a
decimal format, and then multiply by 24 to get the decimal representing
the time value.