Thread: How do I convert time (2:30) to a number (2.5) in a formula?
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default
=A1*24 and format as general.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tammyj" wrote in message
...
The difference in time between 12:00 am and 2:30 am is 2:30. How do I
convert that to a decimal (2.5) in the same formula?


Reply With QuoteReply With Quote