Another Time Related Question

C

cmiedaner

I have 2 times:

A) 4:12:31 PM
B) 4:07:45 PM

In a cell I have the formula (TimeB - TimeA). The cell displays a strange number as a result - 23:55:14. I was hoping it would display the actual time difference (negative or positive).

Is that possible ?

Thanks in advance.
 
M

mcsis87

I have 2 times:



A) 4:12:31 PM

B) 4:07:45 PM



In a cell I have the formula (TimeB - TimeA). The cell displays a strange number as a result - 23:55:14. I was hoping it would display the actual time difference (negative or positive).



Is that possible ?



Thanks in advance.

=TEXT(B1-A1;"hh:mm:ss")
 
P

Paga Mike

I have 2 times:

A) 4:12:31 PM
B) 4:07:45 PM

In a cell I have the formula (TimeB - TimeA). The cell displays
strange number as a result - 23:55:14. I was hoping it would display th
actual time difference (negative or positive).

Is that possible ?

Thanks in advance.

Format the result cell as:
hh:mm:ss
If you anticipate a negative result, you should use the 1904 Date syste
 
C

cmiedaner

;1605406 Wrote: > I have 2 times: > > A) 4:12:31 PM > B) 4:07:45 PM > > In a cell I have the formula (TimeB - TimeA). The cell displays a > strange number as a result - 23:55:14. I was hoping it would display the > actual time difference (negative or positive). > > Is that possible ? > > Thanks inadvance. Format the result cell as: hh:mm:ss If you anticipate a negative result, you should use the 1904 Date system -- Paga Mike

Thanks All. I tried what was suggested but still get this result:

A) 11:21:49
B) 11:21:14

B - A = 23:59:25

Any thoughts ?
 
P

Paga Mike

strange number as a result - 23:55:14. I was hoping it would display th
anticipate a negative result, you should use the 1904 Date system -
Paga Mike-

Thanks All. I tried what was suggested but still get this result:

A) 11:21:49
B) 11:21:14

B - A = 23:59:25

Any thoughts ?

With the 1904 Date system switched on I get:

-0:00:3
 
C

Caveman1957

1904 date system is turned on for a workbook under
options-advanced-When calculating this workbook.

I had to search for it so I thought I would save other people th
trouble ;
 
D

DeFautT

I have 2 times:

A) 4:12:31 PM
B) 4:07:45 PM

In a cell I have the formula (TimeB - TimeA). The cell displays
strange number as a result - 23:55:14. I was hoping it would display th
actual time difference (negative or positive).

Is that possible ?

Thanks in advance.

This looks correct for what you are asking. Thinking in pure mat
terms, you are subtracting a large number from a smaller one which wil
always return a negative number. To get the difference between the tw
times, you need to subtract the start time (4:07:45) from the end tim
(4:12:31)
 

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

Top