Split by 30 mins...

[mahmed1]

Hi - thanks to Fluff who kindly helped me transpose my data in another thread - he has advised to raise a new thread as the question is different to other thread..


I have data transposed by day butsplit it like this and the value Stays the same for each interval from 00:00, 00:30,01:00...23:30

Eg..

Team Date Period Incoming
Team1 01/01/2020 00:00 48
Team1 01/01/2020 00:30 48.
Team1 01/01/2020 01:00 48.....
Team1 01/01/2020 23:30 48
Team2 01/01/2020 00:00 55
Team2 01/01/2020 00:30 55....
Team2 01/01/2020 23:30 55

so the 3rd column has Period

 

[mahmed1]

Hopefully ive been clear enough- apologies if i havnt - please let me know if you require more info

thanks