![]() ![]() ![]() Internally, Excel tracks times as decimal numbers, where 1 hour = 1/24, 1 minute = 1/(24*60), and 1 second = 1/(24*60*60). 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |