Hi folks,
I hope you are all well? I am having an issue with my pivot table, I have times in my raw data and I want to work out what the % of the columns F to O against column D, When I try I have converted it to different formats but either get a 1 or 24:00 so not able to convert to a %.
I hope this makes sense and I have added a picture, any help would be great.
Thanks in advance
Rob
I hope you are all well? I am having an issue with my pivot table, I have times in my raw data and I want to work out what the % of the columns F to O against column D, When I try I have converted it to different formats but either get a 1 or 24:00 so not able to convert to a %.
I hope this makes sense and I have added a picture, any help would be great.
Thanks in advance
Rob