see:

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

same logic works for hours as degrees
--
Gary''s Student - gsnu200719


"CDA" wrote:

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.