time value

[Todd]

I am trying to convert times. Right now I have times formated like 1:40
and I need to multiply the times by a per minute rate.

so something like 1:40 becomes = 60 + 40 = 100 so that I can multiply by the
rate (
100*5.37 )

I know I am making this harder than I should. What is a simple way to do
this?

Thanks

 

[Ron Coderre]

To Excel 1:40 is the formatted version of 0.0694444444444444
which is 100 min / (24hrs x 60min per hr)

So if you're starting with a time value of 1:40 in cell A1, try this:

B1: =A1*(24*60)
in this instance, B1 returns 100

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Todd]

Yes it does. Thank you. All I had thought of so far was to add
minute()+hour() and of course was heading down the wrong path.

Thanks again.

Todd