Excell conversion problem

[rex]

I require some help in the conversion of time to a decimal. What I am looking for is to convert hours mins and seconds into a decimal based around the minutes. For example

2 mins 15 seconds would be converted to 2.25.
3 hours 25 mins and 30 seconds would be converted to 205.5 (ie. 3x60 + 25 + 0.5)

I have tried looking it up on microsoft help but to no avail.

Hope a exel guru can help

[rex]

Found out how to do what I need. Just need to multiply by 1440.

[Big Al.]

rex said:

Found out how to do what I need. Just need to multiply by 1440.

Fails to amaze me this site put up a question and within the hour and the right answer comes back.




Shall I close it for you?

[rex]

That would be good. Not a thread to go down in the PH hall of fame.