Filed under Date & Time

Summarize hours in Excel

Sometimes it’s a little tricky to summarize hours in Excel. Let’s say you want to add together your working hours (or your employee’s). You make a table like this and use the SUM function to add them together. Look what happens: The sum is 13:45 instead of the expected 37:45. That’s 24 hours less than we … Continue reading