Calculate time difference with specific criteria

[Agil]

Hi,


How do I calculate time difference. This is the format in which I have the data (Given below). I need to add two criteria. 1. The clock should start at 9 AM and end at 6 PM 2. The clock should stop on Friday 6 PM and start again only on Monday at 9 AM.


01/03/2011 03:17:00 PM 07/03/2011 06:17:00 PM

 

[Hui]

Agil


have a read of

http://chandoo.org/wp/2010/08/27/working-hours-between-2-dates/

and

http://chandoo.org/wp/2010/09/10/working-hours-formula/


They should help you out.

 

[Agil]

Thank you.


It really helped me solve the problem