How do I format a cell to turn time into numbers? 9:00 am to 12:15

[JE McGimpsey]

Hart to tell what you're asking for, but XL stores times as fractional
days, so multiplying time by 24 will give integral hours:

A1: 09:15
A2: =A1*24 ===> displays 9.25 when formatted as General



<Nothing>

 

[Smartster]

I guess I was not clear of what I was asking. I am trying to turn anlog time
into a whole number Ie: 9:15 am to 12:15 pm would be three hours.

 

[Smartster]

A1 9:00 am A2 12:15 pm A3 would equal 3.25 hours
Thank you very much for tye quick response !!

 

[JE McGimpsey]

One way:

A3: =(A2-A1)*24

formatted as General or another number format.