I have a start time and end time in Col A & Vol B. Then i have 24 hourly intervals in next 24 columns. What I need is the time spent in each hourly interval
e.g.
Start Time: 3:20 am
End time: 5:10 pm
Interval:
00:00 to 01:00 00
01:00 to 02:00 00
02:00 to 03:00 00
03:00 to 04:00 40
04:00 to 05:00 60
05:00 to 06:00 10
06:00 to 07:00 00
07:00 to 08:00 00
e.g.
Start Time: 3:20 am
End time: 5:10 pm
Interval:
00:00 to 01:00 00
01:00 to 02:00 00
02:00 to 03:00 00
03:00 to 04:00 40
04:00 to 05:00 60
05:00 to 06:00 10
06:00 to 07:00 00
07:00 to 08:00 00