sum answer is not right ?

digga

New Member
Joined
Dec 27, 2009
Messages
2
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,812
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
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.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,095,971
Messages
5,447,610
Members
405,458
Latest member
newbie111

This Week's Hot Topics

Top