Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
The Total hours seem fine. What formula are you using for Core hours?
Hours Not adding up in Excel
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I can't get the hours to add up in excel from this report. I have formatted all to [h]:mm and it still won't work!!
| Mon | Tue | Wed | Thu | Fri | Sat | Sun | Total | CoreHours |
|---|---|---|---|---|---|---|---|---|
| 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 37:30 |
| 07:30 | 07:30 | 07:30 | 07:30 | 07:30 | 0:00 | 0:00 | 37:30 | 37:30 |
| 07:30 | 07:30 | 07:30 | 07:30 | 0:00 | 0:00 | 0:00 | 30:00 | 30:00 |
| 0:00 | 0:00 | 0:00 | 04:30 | 04:00 | 0:00 | 0:00 | 08:30 | 37:30 |
| 07:30 | 07:30 | 07:30 | 07:30 | 07:30 | 0:00 | 0:00 | 37:30 | 37:30 |
| 07:30 | 07:30 | 07:30 | 07:30 | 07:30 | 0:00 | 0:00 | 37:30 | 37:30 |
| 07:30 | 07:30 | 07:30 | 07:30 | 07:30 | 0:00 | 0:00 | 37:30 | 37:30 |
| 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 |
| 07:30 | 07:30 | 09:45 | 08:15 | 0:00 | 0:00 | 0:00 | 33:00 | 37:30 |
| 01:15 | 02:30 | 02:00 | 02:30 | 00:30 | 0:00 | 0:00 | 08:45 | 37:30 |
| 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 |
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
1 answer
Sort by: Most helpful
-
Anonymous
2024-07-23T13:50:52+00:00