Microsoft Office Tutorials and References

In Depth Information

**Converting decimal hours, minutes, or seconds to a time**

Converting decimal hours, minutes, or seconds to a time

To convert decimal hours to a time, divide the decimal hours by 24. For example, if cell A1

contains 9.25 (representing hours), this formula returns
09:15:00
(9 hours, 15 minutes):

=A1/24

To convert decimal minutes to a time, divide the decimal hours by 1,440 (the number of

minutes in a day). For example, if cell A1 contains 500 (representing minutes), the

following formula returns
08:20:00
(8 hours, 20 minutes):

=A1/1440

To convert decimal seconds to a time, divide the decimal hours by 86,400 (the number of

seconds in a day). For example, if cell A1 contains 65,000 (representing seconds), the

following formula returns
18:03:20
(18 hours, 3 minutes, and 20 seconds):

=A1/86400

Adding hours, minutes, or seconds to a time

You can use the
TIME
function to add any number of hours, minutes, or seconds to a time.

For example, assume that cell A1 contains a time. The following formula adds 2 hours and

30 minutes to that time and displays the result:

=A1+TIME(2,30,0)

You can use the
TIME
function to ﬁ fill a range of cells with incremental times. Figure 16.8

shows a worksheet with a series of times in ten-minute increments. Cell A1 contains a time

that was entered directly. Cell A2 contains the following formula, which was copied down

the column:

=A1+TIME(0,10,0)

FIGURE 16.8

Using a formula to create a series of incremental times