Counting Hours & Days from a Text Download
Posted by David on April 03, 2001 9:54 AM
I am taking a TSO Download in text fromat that has a work order Open date & time and Work order Closed Date and time and importing it into excel. My question is how do I take those (4 cells) 2 open and 2 closed cells and come up with either days and hours or just total hours the Work order has been opened?
All help is greatly appreciated
David