sum answer is not right ?

[digga]

hi trying to set up a job sheet template to keep track of hours and materials on the job can get the material side of things sorted ok item cost quantity and total all add up fine . but when i try sum to add up the hours worked on the job it comes up with the wrong answer ? is there a way to attach the speadsheet so you might be able to see where im going wrong ?

thanks in advance

 

[RoryA]

Welcome to the forum.

If you are summing up hours, you may simply need to format the cell with a custom number format of [h]:mm so that it will display times over 24 hours.

 

[digga]

thank you so much for your help much appreciated