Time Question

  • Thread starter Thread starter Scooterdog
  • Start date Start date
S

Scooterdog

Have formatted cells using date and time or just time.
I get a answer of 22:00 hours in row A3 on both formats when I enter
11:00 AM in row A1 and 11:00 AM in row A2. In A3 I type: =A1+A2.
What does it take to get the answer of 24:00 hours?

In the time and date format, I entered like this: 11:00 07/25/2003
in row A1 and 11:00 07/26/2003 in row A2. Still get 22:00 hours.
Any help appericated
Thank you
 
Scooterdog,

XL stores time as parts of a day and each day has a value of 1.

To determine that 11:00 AM today is 24 hours after 11:00 yesterday for
example

A1 = Today = 7/26/00 11:00:00 AM
A2 = Yesterday = 7/25/00 11:00:00 AM

Time difference = A1-A2 = 24 (formatted as Format|Cell|Custom "[hh]"
without the ""

or A1-A2 * 24 = 24 and format as general

HTH

PC
 
Paul,

I think you mean

=(A1-A2)*24

--

HTH

Bob Phillips

Paul Corrado said:
Scooterdog,

XL stores time as parts of a day and each day has a value of 1.

To determine that 11:00 AM today is 24 hours after 11:00 yesterday for
example

A1 = Today = 7/26/00 11:00:00 AM
A2 = Yesterday = 7/25/00 11:00:00 AM

Time difference = A1-A2 = 24 (formatted as Format|Cell|Custom "[hh]"
without the ""

or A1-A2 * 24 = 24 and format as general

HTH

PC

Scooterdog said:
Have formatted cells using date and time or just time.
I get a answer of 22:00 hours in row A3 on both formats when I enter
11:00 AM in row A1 and 11:00 AM in row A2. In A3 I type: =A1+A2.
What does it take to get the answer of 24:00 hours?

In the time and date format, I entered like this: 11:00 07/25/2003
in row A1 and 11:00 07/26/2003 in row A2. Still get 22:00 hours.
Any help appericated
Thank you
 
Back
Top