Quick answer
Add the recorded durations in exact minutes or seconds, group the result by project, and convert to decimal hours only after totaling.
Step by step
- Give every entry a project label and one consistent duration format, such as hours:minutes. Identify duplicate or overlapping entries before totaling.
- Convert each row to exact minutes. Sum rows by project, then add the subtotals to get the full log.
- Convert the grand total to a mixed duration or divide the exact minutes by 60 for decimal hours. Round only the displayed report.
Worked examples
Project subtotals
Project A has 0:35 and 0:50, totaling 85 minutes. Project B has 1:05, or 65 minutes. The subtotals sum to 150 minutes, or 2:30.
Handle concurrent work
If two labels describe the same 15-minute interval, counting it twice changes the total. Use one entry or allocate parts according to how your report defines time.
What to check
Compare the sum of all rows with the sum of project totals. If you have clock punches and breaks instead of durations, compute each net shift first.
Related guides
Sources
See the calculation methodology or report an error.