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

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

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

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

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What does the exclamation point (!) stand for in a math equation . scorpionest Excel Discussion (Misc queries) 8 December 3rd 06 10:33 PM
math symbols functions Fontless New Users to Excel 1 March 6th 05 08:36 PM
Cell Reference Math Ralph Howarth Excel Worksheet Functions 0 January 26th 05 06:27 PM
Nested If/Then Math Expert Needed Steven Excel Worksheet Functions 1 January 5th 05 09:52 PM
How do I do math on a cell name in formula? Mark Mulik Excel Worksheet Functions 3 November 23rd 04 03:43 PM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017