D
Dawn Settles via OfficeKB.com
I have to convert 1 4/5 into minutes. I know 1=60 min. I'm not to good at
math and can't figure out 4/5 into minutes.
math and can't figure out 4/5 into minutes.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
If 5/5 is one hour then 1/5 must be 12 minutes thus 4/5 must be 48 minutes
R
RagDyeR
with 1 4/5 in A1:
=A1*60
Returns 108
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I have to convert 1 4/5 into minutes. I know 1=60 min. I'm not to good at
math and can't figure out 4/5 into minutes.
=A1*60
Returns 108
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I have to convert 1 4/5 into minutes. I know 1=60 min. I'm not to good at
math and can't figure out 4/5 into minutes.
P
Peo Sjoblom
I might add that assume you have 1 4/5 in A1 then you can use
A1/24 to get excel time format (format as [hh]:mm) will return 01:48
A1/24 to get excel time format (format as [hh]:mm) will return 01:48
S
Steve Walton
I have to convert 1 4/5 into minutes. I know 1=60 min. I'm not to good at
math and can't figure out 4/5 into minutes.
let Excel do the calculation
enter into A1
=(1+4/5)*60
Steve