Elapsed time
 

Greetings,

I am trying to do a formula and I am driving myself mad. Here is what
I am trying to do hoping someone could help me. I have 2 columns of
dates in the format of "1/4/05 14:04" I want to find the elapased time
between the two columns. With a result of something like "4 days, 2
hours, 12 minutes" Can anyone help me figure this out? Any help would
be appreciated guys.

Regards,
cd


--
relux
------------------------------------------------------------------------
relux's Profile: http://www.excelforum.com/member.php...o&userid=20029
View this thread: http://www.excelforum.com/showthread...hreadid=346133

Try the following...

=INT(B1-A1)&" days, "&INT(24*MOD(B1-A1,1))&" hours, and
"&ROUND(60*MOD(24*(B1-A1),1),0)&" minutes"

...where A1 contains the start time and B1 contains the end time.

Hope this helps!

relux Wrote:
Greetings,

I am trying to do a formula and I am driving myself mad. Here is what
I am trying to do hoping someone could help me. I have 2 columns of
dates in the format of "1/4/05 14:04" I want to find the elapased time
between the two columns. With a result of something like "4 days, 2
hours, 12 minutes" Can anyone help me figure this out? Any help would
be appreciated guys.

Regards,
cd


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=346133