I have a spreadsheet which includes information on what times customers have called our department. I want to be able to count the number of calls in half hourly periods so i can see if we are busier in the morning, lunchtime, afternoon.
Does anyone have any formuals that will count cells, which are between 9 and 9:30, 9:30 and 10 etc etc. my times are in the format HH:MM
Thanks in advance
Kerrie
Does anyone have any formuals that will count cells, which are between 9 and 9:30, 9:30 and 10 etc etc. my times are in the format HH:MM
Thanks in advance
Kerrie