Elapsed time

R

relux

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
 
D

Domenic

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!
 
Top