Quote from
Richard on 8 August 2019, 7:08 am
Hi James
You can get the hours done for each job from the check sheet report. More information including a step by step guide to generating it is available on our support page - completed check sheet report.
With regards to the report messing up, I checked one of your reports and it is because you have a comma in the reference field. Microsoft Excel breaks each column using the comma so for the rows that contain a comma in the reference field, the fields are getting pushed out.
You can remove the comma from the specific job either before you run the report or after you have run the report.
Thanks
Richard
Hi James
You can get the hours done for each job from the check sheet report. More information including a step by step guide to generating it is available on our support page - completed check sheet report.
With regards to the report messing up, I checked one of your reports and it is because you have a comma in the reference field. Microsoft Excel breaks each column using the comma so for the rows that contain a comma in the reference field, the fields are getting pushed out.
You can remove the comma from the specific job either before you run the report or after you have run the report.
Thanks
Richard