I have a start time (BG13) and a finish time (BH13) which could contain any start and finish time (even start time today, finish time is tomorrow)..... is it possible to count how many 30 minute blocks are between (and including) those times?
as example 5:30am start, 7:38 start (it is 2 hours I know) but there are 5 x 30 minute values.....
5:30 = 1
6:00 = 2
6:30 = 3
7:00 = 4
7:30 = 5
hope this makes sense.
as example 5:30am start, 7:38 start (it is 2 hours I know) but there are 5 x 30 minute values.....
5:30 = 1
6:00 = 2
6:30 = 3
7:00 = 4
7:30 = 5
hope this makes sense.