Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What does the exclamation point (!) stand for in a math equation . | Excel Discussion (Misc queries) | |||
math symbols functions | New Users to Excel | |||
Cell Reference Math | Excel Worksheet Functions | |||
Nested If/Then Math Expert Needed | Excel Worksheet Functions | |||
How do I do math on a cell name in formula? | Excel Worksheet Functions |