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.
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.