Many thanks to all you guys.
Have just returned from my managers last whim to see that you have given me loads of things to try.
great to see that there are people out there who want to help. I do hope that i can contribute something back to the board in the future.
Nik
niknokio
Last Activity: Dec 6 '06, 03:15 PM
Joined: Oct 27 '06
Location:
-
Anything you can do would be much appreciated thank you. There is no major panic as i'm being sent off on another adventure for the next 10 days anyway so at least i get some breathing space :-)
Thanks again for responding and in advance for any help you can offer.
NickLeave a comment:
-
No worries and thanks for responding
working hours are between 08:30 to 17:00 - no breaks - its a call centre :-)
yes the requirement is similar. I'm looking at call data so if StartDate = 11/09/2006 09:30:00 & EndDate is 26/09/2006 11:30:15 there are 11 days 2 hours and 15 seconds of working time between opening and closing calls.
hope this makes it clearer
Nick...Leave a comment:
-
working hours between two times
Hi
I need to be able to calculate the working time between a StartDate and an EndDate. the data is in dd/mm/yyyy hh:mm:ss format and given an 8.5 hr day (weekdays). Ive found lots of really useful stuff on this list but nothing that really does it for me. I've have used a bit of code that lets me know the days
Public Function GetNumberOfWork Days(sStartDate , sEndDate)
Dim iDays
Dim iWorkDays...
No activity results to display
Leave a comment: