need time conversion formula

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
 
P

pikus

seconds/60
minutes/60
hours/24

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

David Coleman

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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
D

Dave WL

=HOUR("cell with time in it")+(MINUTE("cell with time in it")/60)

This decimalizes it
 
Top