Remember Me?

#1
April 23rd 05, 04:32 PM
 Dawn Settles via OfficeKB.com Posts: n/a
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
April 23rd 05, 04:48 PM
 Peo Sjoblom Posts: n/a

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
April 23rd 05, 04:54 PM
 RagDyeR Posts: n/a

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
April 23rd 05, 04:55 PM
 Peo Sjoblom Posts: n/a

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
May 23rd 05, 02:36 PM
 Steve Walton Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post scorpionest Excel Discussion (Misc queries) 8 December 3rd 06 11:33 PM Fontless New Users to Excel 1 March 6th 05 09:36 PM Ralph Howarth Excel Worksheet Functions 0 January 26th 05 07:27 PM Steven Excel Worksheet Functions 1 January 5th 05 10:52 PM Mark Mulik Excel Worksheet Functions 3 November 23rd 04 04:43 PM

All times are GMT +1. The time now is 09:34 PM.