Hi Team,
I work in a call centre and trying to write a formula
which allow me to classify calls received / abandoned between 30
minute intervals .

Time abandoned No of calls Time

9:00:00 am 1 This is where I need the formula (output
should say 9:00-9:30 am
9:08:00 am 1 output should say 9:00-9:30 am
9:10:00 am 1 output should say 9:00-9:30 am
9:34:00 am 1 output should say 9:30-10:00 am
9:54:00 am 1 output should say 9:30-10:00 am
10:00:00 am 1 output should say 10:00-10:30 am
10:15:00 am 1 output should say 10:00-10:30 am
10:30:00 am 1 output should say 10:30-11:00 am