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 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" <forum@nospam.OfficeKB.com> wrote in message
news:dbf4db990043420fb62cb9c4bf189cd5@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.
>
> --
> 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" <terre08@mvps.org> wrote in message
news:%23fxSwvBSFHA.2132@TK2MSFTNGP14.phx.gbl...
> 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" <forum@nospam.OfficeKB.com> wrote in
> message news:dbf4db990043420fb62cb9c4bf189cd5@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.
>>
>> --
>> 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" <forum@nospam.OfficeKB.com> wrote in message
news:dbf4db990043420fb62cb9c4bf189cd5@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.
--
Message posted via http://www.officekb.com
On Sat, 23 Apr 2005 15:32:17 GMT, "Dawn Settles via OfficeKB.com"
<forum@nospam.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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks