HI Guys
In the attached spreadsheet I am trying to identify each time the format changes during the day in column J such as to eventually identify the start and finish time of the format (as explained in column K). I have tried in column J to create a formula to detect the format changeover in column C but the zero values in column C are leading to errors in my formula.
Do I need to create extra helper columns to help sort the data? I would appreciate any help possible
Thanks
Chris