Calculating the difference between two dates AND times

[jeffhole]

Hello,
I need some help with datediff and/or networkdays. Or something. I have several columns populated with both dates and times in this format -> mm/dd/yyyy hh:mm:ss

They look like this:

Column A
11/16/2011 13:19:07
11/14/2011 17:19:06

Column B
11/17/2011 07:19:56
11/18/2011 11:01:56


I need to figure out how to find the amount of time between the two columns. I searched and couldn't find exactly what I was looking for. The trouble I'm having is with incorporating the time along with the date. Excel formulas or VBA solutions will work, I'm not picky, just braindead :D I'm hoping the solution is an easy one that I overlooked.

Thank you very much.

 

[roentgen]

Hi

Just deduct the cells and use a custom format [hh]:mm to give total hours and minutes.