need time conversion formula

[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

 

[pikus]

seconds/60
minutes/60
hours/24

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

 

[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

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Dave WL]

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

This decimalizes it