Gents,
Hopefully someone can give me some guidance on the best way to implement the following issue. I have a spreadsheet detailing phone calls being made from our offices. The spreadsheet has a column detailing the date and time the call was placed. The date and time is formatted as follows:-
2011/01/14 09:09:00 AM
2011/01/13 07:43:00 PM
I need to use a VBA macro to identify if the call was placed during peak hours. My peak hours are 07:00 am to 19:00 pm Mon to Fri.
Can anyone help or guide me in the right direction?
Many thanks in advance,
Lee.
Hopefully someone can give me some guidance on the best way to implement the following issue. I have a spreadsheet detailing phone calls being made from our offices. The spreadsheet has a column detailing the date and time the call was placed. The date and time is formatted as follows:-
2011/01/14 09:09:00 AM
2011/01/13 07:43:00 PM
I need to use a VBA macro to identify if the call was placed during peak hours. My peak hours are 07:00 am to 19:00 pm Mon to Fri.
Can anyone help or guide me in the right direction?
Many thanks in advance,
Lee.