How do I go from time to decimal if over 24hrs

[CDA]

I am struggling to find an answer and hope you can help. Is there a way to
convert time in HH:MM:SS (or just HH:MM) to a number in Excel? For example:



135:30:00
?

140:48:12
?






In this example I would like the first ? to reflect 135.5 while the second
would be something along the lines of 140.8. Can I create a formula that
would do this for me in a table full of times? Please advise.

 

[Gary''s Student]

see:

http://www.cpearson.com/excel/latlong.htm

same logic works for hours as degrees

 

[CDA]

Would it be possible to show me how this would look on one of the examples?

Thanks so much for this reference I really appreciate it!