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