I have a decimal, 17.62 and I want to turn it into Hours and Minutes. I want it to end up as 17 hours and 0.62 of a minute, which is about 17:37.
Basically, I need a formula to work out hours and minutes from a decimal.
(First answer that works, gets the points. So go!)
=D
2007-04-15 06:03:04 · 7 answers · asked by Anonymous in Computers & Internet ➔ Software
Oh, I'ld like it in the hh:mm format too. Thanks.
2007-04-15 06:06:22 · update #1
Dates in excel are represent as real number where the left side of the decimal represents teh number of days since 1JAN1900. The right side of the decimal is the time since midnight in hours and is a fraction of 24 hours.
so you have 17 hours. divide it by 24 and you will have time in a decimal format the excell can format. Simple right click the cell with the decimal and select TIME as teh format type.
To incorporate minutes and seconds just convert them into the fractional part of 24 hrs and add them to your 17/24 fraction.
12min = 12/60 hrs = .2hrs
17.2 hrs / 24 = .716666 format this into time and you'll get
5:12 PM
2007-04-15 06:27:18 · answer #1 · answered by MarkG 7 · 0⤊ 0⤋
This will give the time to the nearest minute:
Enter your decimal in cell A1
in B1 enter: =INT(A1)
in C1 enter: =60*(A1-B1)
and in D1 enter: =TIME(B1,C1,0)
To format D1 go to the Format menu:
Cells
Number tab
Category: Time
and Type: 13:30
I think that's what you want.
If it works you can hide columns B and C to make your sheet look better.
2007-04-15 06:39:26 · answer #2 · answered by Anonymous · 0⤊ 0⤋
If your cell A1 has 17.62
in cell B1 type =A1/24
Now format B1 as hh:mm
It will give you the desired result i.e. 17:37
2007-04-15 20:24:31 · answer #3 · answered by Dilip Rao 3 · 0⤊ 0⤋
Hours = Minutes / 60 + seconds / 3600 I don't know what form your "minutes & seconds" is in, so I can't give much more information. If it's a four digit number, like 2343, you might try this: Minutes = int( number / 100) Seconds = number - minutes * 100
2016-05-20 22:35:28 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Basically I only know one way and that is to right click choose format and time,then choose which ever format.
2007-04-15 06:19:26 · answer #5 · answered by Anonymous · 0⤊ 0⤋
you use the format key or button hope this helps
2007-04-15 06:19:12 · answer #6 · answered by kessin72 2 · 0⤊ 0⤋
Put your decimal in cell A1
Then enter this formula in B1
=INT(A1)&":"&
ROUND((A1-INT(A1))*60,0)
2007-04-15 07:56:10 · answer #7 · answered by eric_twice 2 · 0⤊ 0⤋