J JE McGimpsey Aug 22, 2004 #2 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>
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>
G Guest Aug 22, 2004 #3 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.
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.
G Guest Aug 22, 2004 #4 A1 9:00 am A2 12:15 pm A3 would equal 3.25 hours Thank you very much for tye quick response !!
J JE McGimpsey Aug 23, 2004 #5 One way: A3: =(A2-A1)*24 formatted as General or another number format.
