How do I find elapsed time between 2 dates and times?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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")
 
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 said:
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 said:
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 said:
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 said:
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 said:
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 said:
=SUM(C4:C5)-SUM(C2:C3)

format as [hh]:mm

--
Regards,

Peo Sjoblom


Alistair said:
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 said:
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")




:

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.
 
Back
Top