How do I convert time (2:30) to a number (2.5) in a formula?

T

tammyj

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?
 
B

Bob Phillips

=A1*24 and format as general.

--

HTH

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