View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lea777
 
Posts: n/a
Default Calculating Date AND Time Differences




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