Time Calculation

[Guest]

How do I calculate the elapsed time between the following dates:
2/2/02 09:15
2/3/02 17:15

 

[GaryB]

Assuming that you don't want a decimal answer (28.3333 days) which you can get by simply subtracting one from the other....

With your first time in A1, the second in A2 you could try...
=CONCATENATE(TRUNC(A2-A1)," days ",TRUNC((A2-A1-TRUNC(A2-A1))*24)," hours ",TRUNC(((A2-A1-TRUNC(A2-A1))*24)-TRUNC((A2-A1-TRUNC(A2-A1))*24))*60, " minutes")

which will give you
"28 days 8 hours 0 minutes" as text

HTH

GaryB
This message was edited by GaryB on 2002-02-28 00:57

 

[Aladin Akyurek]

On 2002-02-27 21:27, Anonymous wrote:
How do I calculate the elapsed time between the following dates:
2/2/02 09:15
2/3/02 17:15

In C2 enter:

=((B2-A2)*24)/24

where A2 is earlier in time than B2 (that is, B2 > A2, wrt to date.

Custom format C2 as [h]:mm

I get wrt the example: 32:00

Is this what you're looking for?

 

[Guest]

There seems to be quite a discrepency between the offered solutions - is your later date 3-FEB-02 or 2-MAR-02 ??

 

[Aladin Akyurek]

On 2002-02-28 02:51, Anonymous wrote:
There seems to be quite a discrepency between the offered solutions - is your later date 3-FEB-02 or 2-MAR-02 ??

Never assume everybody encodes the world as you do. Seeing

"How do I calculate the elapsed time between the following dates:
2/2/02 09:15
2/3/02 17:15"

I assumed American usage: mm/dd/yy

that is:

2-Feb-02 09:15
3-Feb-02 17:15

where 3-Feb-02 is later in time, if you ask me.