Explanation
Excel times are fractional numbers.
This means you’re able to add times together with theSUM functionto get total durations.
For example, to enter a time of 9 minutes, 3 seconds, bang out: 0:09:03.
How Excel displays time depends on what number format is applied.
This usually means you will need to apply acustom number formatto certain cells before you enter the time.
In that case, you will need to adjust the custom time format before entering the times.
you’ve got the option to add h or [h] if needed to handle hours.
Related functions
SUM Function
The Excel SUM function returns the sum of values supplied.
These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
SUM can handle up to 255 individual arguments.
