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

A

Alistair

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.
 
P

Peo Sjoblom

=A2-A1

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

Yogi Anand--www.energyefficientbuild.com

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")
 
A

Alistair

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.
 
P

Peo Sjoblom

=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.
 
A

Alistair

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.
 

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