How to sum more than 24 hours in Excel
Did Excel make a mistake in the sum? Does it not sum for more than 24 hours?
If you're not paying attention, you might not notice, but by default Excel only sums up to 23:59 and then resets the total, turns midnight to 00:00, and starts the count all over again.
Luckily, correcting this is very simple. To get the correct result, you need to make a small change to your cell formatting.
Tell me, were you aware of this little "error"?
#excel #spreadsheets #excelspreadsheets #exceltip #dashboard #report #excelcourse