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

=A1*24 and format as general.

--

HTH

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


"tammyj" <[email protected]> wrote in message
news:[email protected]...
> 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?

=A1*24 and format as general.

--

HTH

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


"tammyj" <[email protected]> wrote in message
news:[email protected]...
> 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?

=A1*24 and format as general.

--

HTH

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


"tammyj" <[email protected]> wrote in message
news:[email protected]...
> 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?

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?

=A1*24 and format as general.

--

HTH

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


"tammyj" <[email protected]> wrote in message
news:[email protected]...
> 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?