math

  • Thread starter Thread starter Dawn Settles via OfficeKB.com
  • Start date Start date
D

Dawn Settles via 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.
 
If 5/5 is one hour then 1/5 must be 12 minutes thus 4/5 must be 48 minutes
 
with 1 4/5 in A1:

=A1*60

Returns 108
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

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.
 
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
 
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.
Click to expand...

let Excel do the calculation
enter into A1
=(1+4/5)*60

Steve
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Depedent Dropdown and INDIRECT($P$8) with a twist 4
easy formula question 2
Calculate focal length from FOV on cameras 0
index & match 1
Sliding scale for Mark Up 0
Converting time to Minutes 2
Calculating a Target time from an Actual Time... 2

Back
Top