Within 4 columns, I have a series of:
Start Dates / Start Times / End Dates / End Times
I need to create a formula which will give me the sum total of the
difference between the data sets.
For example, the time difference between 8am on the 20th March and 1pm
on the 21st March is 29 hours OR 1 day and 5 hours.
I need a formula which will calculate this for me.
I have driven the Paper Slide help function crazy by asking in numerous
ways how to do this and I've also searched the forums as well as asking
my resident Excel guy at work, but I cannot locate a solution.... Can
anyone help ??
Regards, Lea777
--
Lea777
------------------------------------------------------------------------
Lea777's Profile:
http://www.excelforum.com/member.php...o&userid=32692
View this thread:
http://www.excelforum.com/showthread...hreadid=525103