Associated Topics || Dr. Math Home || Search Dr. Math

### Converting a Decimal Hour

```
Date: 11/22/2001 at 06:50:59
From: Steve Cowle
Subject: Converting a decimal hour

How do I convert 1.7 hours into hours, min, sec? Is there a standard
formula I can use? I would like to put this into an Excel spreadsheet.
```

```
Date: 11/22/2001 at 08:21:26
From: Doctor Jerry
Subject: Re: Converting a decimal hour

Hi Steve,

You can use the "Floor" function in Excel.

Put the letters r, h, r, m, and s in cells A1, A2, A3, A4, and A5.
These stand for the original time (t), the hours (h), a remainder (r),
the minutes (m), and the seconds (s). These are just to help remember
what is where.

In B1 put the time you want converted.  Try 1.82.
In B2 put      =FLOOR(B1,1)
In B3 put      =(B1-B2)*60
In B4 put      =FLOOR(B3,1)
In B5 put      =(B3-B4)*60

The result is that 1.82 is converted to 1 hour, 49 minutes, and 12
seconds.

If you put 1.877 in for t (in B1), you'll get 1 hour, 52 minutes, and
37.2 seconds.

- Doctor Jerry, The Math Forum
http://mathforum.org/dr.math/
```
Associated Topics:
High School Calculators, Computers

Search the Dr. Math Library:

 Find items containing (put spaces between keywords):   Click only once for faster results: [ Choose "whole words" when searching for a word like age.] all keywords, in any order at least one, that exact phrase parts of words whole words

Submit your own question to Dr. Math
Math Forum Home || Math Library || Quick Reference || Math Forum Search