View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CDA[_2_] CDA[_2_] is offline
external usenet poster
 
Posts: 2
Default How do I go from time to decimal if over 24hrs

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.