Dear All
Need an urgent help to get the below scenario sorted.
I have attached 2 sets of Data.
In Sheet2, there is a TV Ad data aired on different channels. Explanation of each column below
Channel: Name of the Channel
Date: Current Date
AD Start: TV AD start Time
MidBreak: Tells about the Mid Break in an Hour. For e.g MidBreak-1, MidBreak-2, MidBreak-3, etc. etc.
Break Start and Break End: These columns tells about the Break time start and Break Time End in a prticular time slot.
In Sheet1, I need an output on New Time Column. This New Time column will populate from Sheet 2 through its Channel Name, Date and Time Slot. New Time column output would be any random time on a specific Channel, Date and Time Slot. I have mentioned few example in the below link in excel.
https://drive.google.com/file/d/1drGK3zzkT5c_axxpClunDRUaIYb8poUz/view?usp=sharing
Thanks,
Haider
Need an urgent help to get the below scenario sorted.
I have attached 2 sets of Data.
In Sheet2, there is a TV Ad data aired on different channels. Explanation of each column below
Channel: Name of the Channel
Date: Current Date
AD Start: TV AD start Time
MidBreak: Tells about the Mid Break in an Hour. For e.g MidBreak-1, MidBreak-2, MidBreak-3, etc. etc.
Break Start and Break End: These columns tells about the Break time start and Break Time End in a prticular time slot.
In Sheet1, I need an output on New Time Column. This New Time column will populate from Sheet 2 through its Channel Name, Date and Time Slot. New Time column output would be any random time on a specific Channel, Date and Time Slot. I have mentioned few example in the below link in excel.
https://drive.google.com/file/d/1drGK3zzkT5c_axxpClunDRUaIYb8poUz/view?usp=sharing
Thanks,
Haider