Ive had a little help in creating a pivot table on my excel workbook but could do with a little more assistance before its completed.
I will attach my dummy excel file hopefully someone can take a look and help me with the last two columns? the excel file is pretty self explanatory
The columns i require help on are time before break and time after break
between hours of 12:00 and 14:00 on each day there is a break of around 1 hour so 01:00:00. Just like with the first time and the last time on each day i wish to state the time before the break and the time after the break, in the attachment I have the pivot table completed without the last two columns