Solution to Problem: Adding up cells with hours - Auto sum does not work once hours exceed 24 - Help!

Adding up cells with hours - Auto sum does not work once hours exceed 24 - Help!

I have a spreadsheet where I enter hours and I need to be able to add them up over a long period of time.  My cells are formatted for time and when I use AutoSum it adds correctly until the total would exceed 24 hours then it does something to the total. 
If I just select the cells and look at the status bar the Sum function on the status bar DOES have the correct number of hours.
Here is an example - the grey cells have the Sum Function adding the cells to the left - notice that it is correct until the last row - it should say that the total number of hours is 28:49 but it gives me a total of 4:49.


2:57
7:08
10:05







2:57
7:08
4:49
14:54







2:57
7:08
4:49
2:40
17:34






2:57
7:08
4:49
2:40
2:10
19:44






2:57
7:08
4:49
2:40
2:10
9:05
4:49






Help!!  I don't understand what is going on!!
Gayle

Keys to the Problem Adding up cells with hours - Auto sum does not work once hours exceed 24 - Help!

Download Error Fixer (Free)

Actually, the formula is calculating the correct value.
The issue is with the number formatting.
When you use h:mm, as soon as you cross 24 hours, that format starts back at zero.
Try this:
• Select the cells to be impacted....your SUM formula cells
• Home.Format.Cell_formatting...Number_tab
...Category: Custom
...Type: [h]:mm
Click: OK
The square brackets around the "h" force Excel to keep displaying in hours.
 
Does that help?

Run CHKDSK to Fix Adding up cells with hours - Auto sum does not work once hours exceed 24 - Help!

• Go to the Start button.
• In the Search box, type "cmd" (without quotes) and press Enter.
• At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
• Reboot your computer.

An error might pop up:

"Access denied as you do not have significant privileges. You have to invoke this utility in elevated mode."

If you receive the above error message, it means you are not logged into you computer as an Administrator. If that's the case, follow these steps to run the command prompt in elevated mode:

• Go to theStart button.
• Go to "All Programs > Accessories" and right click on "Command Prompt".
• Select "Run as Administrator".
• In the Search box, type "cmd" (without quotes) and press Enter.
• At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
• Reboot your computer.

Recommended Method to Repair the Problem: Adding up cells with hours - Auto sum does not work once hours exceed 24 - Help!:

 

 

How to Fix Adding up cells with hours - Auto sum does not work once hours exceed 24 - Help! with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will perform a scan for your system. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.

Related: 1723 There is a problem with this Windows Installer package A DLL required After installing Windows Vista SP2 my computer turns off while not being in use When turned back on I am asked if I want to start my computer normally BSOD in Windows 8 DRIVER POWER STATE FAILURE due to ntoskrnl exe need help with deciphering minidump Bluetooth Driver Not Connected after Windows 8 1 Install Backup in Windows 7 When I try to backup to my Seagate 3 5 inch push button backup 250 GB 2 0 external hard drive Model ST3250 601U2RK my computer shuts down C Windows Installer wiped Can t get admin tools to work in Windows 7 except config sys Cannot open attachments in Windows Mail Cannot use learn moodle as earlier after the Windows Internet Explorer 9 upgrade Changing letter of Windows 7 system partition Application stop working while running them in Windows 7 Deep Freeze Instalado no Windows 7 um grande problema Dell with preinstalled 64 bit Windows 7 shuts down while booting Desktop Icons disappear when right clicking on desktop in Windows 7 Auto rotate has stopped working on Acer 1820PT running Windows 7 in tablet mode DJ Inkers will not work on Windows 7 Is there a way to make it work,Can I sign into two Windows 8 computers using the same microsoft account at the same time realtek drivers download Did Windows 7 backup my hard drive causing the used space to double in one week from 225 Gb to 450 Gb realtek audio drivers InPageCoFire Error Windows Vista Home Basic realtek hd audio driver Query related to availability of date and time of the replied email from the original email in Windows Mail realtek drivers download Starting display problem Your computer did not shut down properly Windows is collecting information realtek driver Windows 7 logon error realtek driver Windows Update repeatedly offered realtek ac97 audio driver three Access the BIOS via either the F1, F2, Del critical, F10 or F11. To locate out which essential it is, watch the screen whilst your pc is booting to check out what keystroke will get you into the BIOS. Look into the Standard information and facts tab to discover the motherboard’s model and BIOS revision.
Read More: How to Fix Error - Excel 2007: Can I SUMIF ( ) by cell colors??,Troubleshooter of Error: Email causes shut down help,How to Fix Problem - Acer Aspire 4330 Windows 7 Touch Pad will not work?,outlook express.com reinstallation [Solved],How to Fix Problem - I have managed to modify the \"New Blank Document\" template in Word 2010.?,Hyperlink issues and changes,Windows 7 fault that prevents reinstallation of software,Remote access using Windows 8.1,Can’t browse specific webpages when using Internet Explorer 8,clearing adobe flash player