I have two columns A and B with times and dates in one cell ie
Date/Time Received Date/Time Returned
15/02/2006 12:44 15/02/2006 17:20
15/02/2006 12:44 15/02/2006 17:06
15/02/2006 12:44 15/02/2006 17:03
02/02/2006 14:27 15/02/2006 16:52
02/02/2006 14:27 15/02/2006 16:44
15/02/2006 16:32 15/02/2006 16:35
15/02/2006 11:01 15/02/2006 16:29
11/01/2006 13:00 15/02/2006 15:24
02/02/2006 14:27 15/02/2006 15:10
Now the cell format is ‘custom’ in name convention (UK format)
dd/mm/yyy hh:mm
Now in Column 3 I need the difference in Days / Hours / Minutes
Also ---- I need non-counting days to be avoided – ie Sat and Sun
There will be series of UpDates to this question with a few twists to the formula
I don’t mind if a VBA UDF is used or an Excel Function, as a lot of additional will be required
Many thanks for trying to help me guys – just something nasty I will have to chip away at, later this will all be MS Access
Jack