Hi,
Thanks you very much for replying, however, I need some further assistance:
If I have a list like the following;
Date Created Date Closed
1. 18/02/10 07:30am 19/02/10 09:00am
2. 19/02/10 09:45am 19/02/10 17:45am
3. 19/02/10 07:30am 20/02/10 01:30am
4. 19/02/10 17:30pm 20/02/10 15:00pm
The answers should read [h]:mm:ss (based on operating hours 365 days 7:30am to 1:30am which equates to an 18 hour working day)
1. 19:30:00
2. 08:00:00
3. 18:00:00
4. 15:30:00
If I use your suggestion, how on earth do I build this into a formula??!?
Edited by roxaneamanda - 20 Jan 2010 at 8:25am