|Subject:||Years, Months, Days, Hours, Minutes, Seconds Formula?|
|Posted by:||Darrell Burnett (axzo509wxu…@ntlworld.com)|
|Date:||Fri, 12 Jan 2007|
Could anyone PLEASE help me with a single cell formula that would take the
difference between TWO cells containing Dates AND Times, and return the
elapsed difference in the following format:
"3 Years, 9 Months, 15 Days, 14 Hours, 8 Minutes, 16 Seconds"
I've been trying all day to come up with it, but so far have only managed to
do the date part!
I would be extremely grateful for any help anyone can offer.