need time conversion formula

  • Thread starter Thread starter mpvijay
  • Start date Start date
M

mpvijay

Hi everybody

How can i convert time into normal 100 value?
i.e. 60 mins should appear as 100
30 mins should appear as 50 etc...
If anybody knows, pls reply me.

thank you
friendly
vija
 
seconds/60
minutes/60
hours/24

Just devide the number you're trying to convert by the number that
equates to 100%. - Pikus
 
Hi Vijay

100/60 * {number of minutes}

Note that you could replace 100/60 with 1.6667 but you may lose accuracy due
to rounding...

Regards

David
 
Hi!

Just to add. If the time is in Excel's time format (e.g.) 0:45 then
just multiply by 24 and format general.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top