Hi.
I have a team of people that record jobs onto a system in the format of dd:hh:mm the sheet could be a weeks worth or a days worth depending on how many days I pull off to review. The column does not have a total and when I try to add the days hours and minutes booked it does not total. Is there a way to do this without a massive formula that takes a long time to input each time I download a sheet. It is downloaded in to an excel file if that makes any difference. Attached a small sample of the times but taken out the guys names. Thanks in advance for any help.
Lee
I have a team of people that record jobs onto a system in the format of dd:hh:mm the sheet could be a weeks worth or a days worth depending on how many days I pull off to review. The column does not have a total and when I try to add the days hours and minutes booked it does not total. Is there a way to do this without a massive formula that takes a long time to input each time I download a sheet. It is downloaded in to an excel file if that makes any difference. Attached a small sample of the times but taken out the guys names. Thanks in advance for any help.
Lee
Last edited: