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

  • Thread starter Thread starter Guest
  • Start date Start date
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>
 
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.
 
A1 9:00 am A2 12:15 pm A3 would equal 3.25 hours
Thank you very much for tye quick response !!
 
One way:

A3: =(A2-A1)*24

formatted as General or another number format.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Discrepancy 2
separating date and time 5
Sum Time 6
Count time formatted data within range 1
Date/Time 1
date & Time 1
Problem formatting dates from CSV file 2
using a time format in a count function 1

Back
Top