Converting time hh:mm:ss into decimal format? mm.ss

Hi,

I need help in making this formula work.

I'm trying to convert a time format into a decimal looking format. The data pool is very large so changing them manually is very time consuming.


Im trying to chage this time format using this formula

Please Login or Register  to view this content.

turning 00:30:05 into 30.05

the formula works perfectly until I encounter the hours

01:30:02 turns to 30.02. I would like it to look like 90.02 (60mins+30mins.02 secs)

I got it!

I finally figured it out. Thank you
here's the working formula

Please Login or Register  to view this content.

Thanks shg!

I think your formula worked better! I found an error with the one i marked as solved.

Question though, where did you get the 1440 value from? i mean what is the relationship of *1440 to time?

awesome!

Genius work.

Thanks a lot!