You must be sure that times are correctly entered in hh:mm:ss format. For example, to enter a time of 9 minutes, 3 seconds, type: 0:09:03Įxcel will show the time in the formula bar as 12:09:03 AM, but will record the time properly as a decimal value. However, you must take care to enter times with the right syntax and use a suitable time format to display results, as explained below. Excel times are fractional numbers. This means you can add times together with the SUM function to get total durations.
