The attachment is extracted from a software called statex, we use it in a media company for us to see how many Advertisements appeared according to the scheduled time per program.
I need an excel formula for below.
1. I want to separate the date and time
2. Combine the time (ex.19:10:36 & 19:19:55) per program (ex. full ticket - as the same time appeared in the same program)
3. also combine SPT (ex. 3 of 9 - highlighted in yellow) per program (ex. full ticket - as the same time appeared in the same program)
Would appreciate if you can help me create a formula for the above as i use to do this the whole day all the time manually.
Thanks a lot.
Bookmarks