I am looking to calculate the difference in two dates listed as 1/4/2010 6:15:12 AM and show minutes for just working days
So if I had 1/4/2010 6:15:12 AM and 1/4/2010 6:46:00 AM (which is mm:dd:ss) I want it to show 31 minutes
If I have 6/14/2010 13:34 and 6/15/2010 12:02 I want it to show 1 day 23 hours and xx minutes
I'd like it to show it in dd:hh:mm (1:23:15) format
I've tried NETWORKINGDAYS - is there something I can nest in that formula or is there another formula that can be used.
I know how to use the datediff function in Access but there is no function like it in Excel 2007. I would prefer a formula however I would add VBA code - however formula is preferred as it is for another user.
Sample data attached