Years, Months, Days, Hours, Minutes, Seconds Formula?

Giganews Newsgroups
Subject: Years, Months, Days, Hours, Minutes, Seconds Formula?
Posted by:  Darrell Burnett (axzo509wxu…@ntlworld.com)
Date: Fri, 12 Jan 2007

Hi Everyone,

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.

Thank you.

Replies