I am using Excel 2003. I have a date and time, each in its own column. I
also have another date and time, each in its own column. I need to find the
exact elapsed time between the two date/time sets, and most of the time, the
elapsed time is over 24 hours. How do I write the formula to give me the
exact elapsed time?

Thank you for any help you can give.

=A2-A1

where A2 is end time and A1 is start time, then format result custom as
[hh]:mm

--
Regards,

Peo Sjoblom


"Alistair" wrote in message
...
I am using Excel 2003. I have a date and time, each in its own column. I
also have another date and time, each in its own column. I need to find
the
exact elapsed time between the two date/time sets, and most of the time,
the
elapsed time is over 24 hours. How do I write the formula to give me the
exact elapsed time?

Thank you for any help you can give.

Hi Alistair:

Let us say yor starting time is in cell C4, and ending time is in cell D4,
then you can use the following ...

=D4-C4 ... and ude Custom Number Format [hh]:mm to get difference in Hours
and Minutes

However if you want the answer in Days, Hours, and Minutes then let us try ...

=INT(D4-C4)&" day "&TEXT(MOD(D4-C4,1),"hh:mm")




"Alistair" wrote:

I am using Excel 2003. I have a date and time, each in its own column. I
also have another date and time, each in its own column. I need to find the
exact elapsed time between the two date/time sets, and most of the time, the
elapsed time is over 24 hours. How do I write the formula to give me the
exact elapsed time?

Thank you for any help you can give.

Yogi,

I was wondering if you could help me on something...For instance, I may have:

C2 C3 C4 C5
| 12/24/2006 | 13:56| and |12/29/2006 | 09:45 |

everything in its own separate column, and elapsed time is almost 5 days. I
need a formula that takes into account the dates, and finds the exact elapsed
time between the two dates and times, whether it occurs in the same day, or
over several.

What do you think?


--
Alistair Maclean


"Yogi Anand--www.energyefficientbuild.com" wrote:

Hi Alistair:

Let us say yor starting time is in cell C4, and ending time is in cell D4,
then you can use the following ...

=D4-C4 ... and ude Custom Number Format [hh]:mm to get difference in Hours
and Minutes

However if you want the answer in Days, Hours, and Minutes then let us try ...

=INT(D4-C4)&" day "&TEXT(MOD(D4-C4,1),"hh:mm")




"Alistair" wrote:

I am using Excel 2003. I have a date and time, each in its own column. I
also have another date and time, each in its own column. I need to find the
exact elapsed time between the two date/time sets, and most of the time, the
elapsed time is over 24 hours. How do I write the formula to give me the
exact elapsed time?

Thank you for any help you can give.

=SUM(C4:C5)-SUM(C2:C3)

format as [hh]:mm

--
Regards,

Peo Sjoblom


"Alistair" wrote in message
...
Yogi,

I was wondering if you could help me on something...For instance, I may
have:

C2 C3 C4 C5
| 12/24/2006 | 13:56| and |12/29/2006 | 09:45 |

everything in its own separate column, and elapsed time is almost 5 days.
I
need a formula that takes into account the dates, and finds the exact
elapsed
time between the two dates and times, whether it occurs in the same day,
or
over several.

What do you think?


--
Alistair Maclean


"Yogi Anand--www.energyefficientbuild.com" wrote:

Hi Alistair:

Let us say yor starting time is in cell C4, and ending time is in cell
D4,
then you can use the following ...

=D4-C4 ... and ude Custom Number Format [hh]:mm to get difference in
Hours
and Minutes

However if you want the answer in Days, Hours, and Minutes then let us
try ...

=INT(D4-C4)&" day "&TEXT(MOD(D4-C4,1),"hh:mm")




"Alistair" wrote:

I am using Excel 2003. I have a date and time, each in its own column.
I
also have another date and time, each in its own column. I need to find
the
exact elapsed time between the two date/time sets, and most of the
time, the
elapsed time is over 24 hours. How do I write the formula to give me
the
exact elapsed time?

Thank you for any help you can give.

Peo,

Thank you!!

--
Alistair Maclean


"Peo Sjoblom" wrote:

=SUM(C4:C5)-SUM(C2:C3)

format as [hh]:mm

--
Regards,

Peo Sjoblom


"Alistair" wrote in message
...
Yogi,

I was wondering if you could help me on something...For instance, I may
have:

C2 C3 C4 C5
| 12/24/2006 | 13:56| and |12/29/2006 | 09:45 |

everything in its own separate column, and elapsed time is almost 5 days.
I
need a formula that takes into account the dates, and finds the exact
elapsed
time between the two dates and times, whether it occurs in the same day,
or
over several.

What do you think?


--
Alistair Maclean


"Yogi Anand--www.energyefficientbuild.com" wrote:

Hi Alistair:

Let us say yor starting time is in cell C4, and ending time is in cell
D4,
then you can use the following ...

=D4-C4 ... and ude Custom Number Format [hh]:mm to get difference in
Hours
and Minutes

However if you want the answer in Days, Hours, and Minutes then let us
try ...

=INT(D4-C4)&" day "&TEXT(MOD(D4-C4,1),"hh:mm")




"Alistair" wrote:

I am using Excel 2003. I have a date and time, each in its own column.
I
also have another date and time, each in its own column. I need to find
the
exact elapsed time between the two date/time sets, and most of the
time, the
elapsed time is over 24 hours. How do I write the formula to give me
the
exact elapsed time?

Thank you for any help you can give.