ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   math (https://www.excelbanter.com/excel-worksheet-functions/23334-math.html)

Dawn Settles via OfficeKB.com

math
 
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.

--
Message posted via http://www.officekb.com

Peo Sjoblom

If 5/5 is one hour then 1/5 must be 12 minutes thus 4/5 must be 48 minutes


--
Regards,

Peo Sjoblom


"Dawn Settles via OfficeKB.com" wrote in message
...
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.

--
Message posted via http://www.officekb.com




RagDyeR

with 1 4/5 in A1:

=A1*60

Returns 108
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Dawn Settles via OfficeKB.com" wrote in message
...
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.

--
Message posted via http://www.officekb.com



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

--
Regards,

Peo Sjoblom


"Peo Sjoblom" wrote in message
...
If 5/5 is one hour then 1/5 must be 12 minutes thus 4/5 must be 48 minutes


--
Regards,

Peo Sjoblom


"Dawn Settles via OfficeKB.com" wrote in
message ...
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.

--
Message posted via http://www.officekb.com






Steve Walton

On Sat, 23 Apr 2005 15:32:17 GMT, "Dawn Settles via OfficeKB.com"
wrote:

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


All times are GMT +1. The time now is 01:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com