|
|
#2
12-13-2024, 09:42 AM
|
|||
|
|||
00:12:33
00 = hours 12 = minutes 33 = seconds Excel is designed to recognize xx:xx as hours and minutes. Excel is also designed to recognize xx:xx:xx as hours/minutes/seconds. No mystery ... it simply is how Excel was designed. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Countdown of Days, Hours, Minutes and Seconds | Chris Waller | PowerPoint | 3 | 01-31-2022 03:22 AM |
| Time Stamp to seconds | RRB | Excel Programming | 1 | 06-15-2021 03:07 AM |
| Format cells to minutes and seconds | RonDBD | Excel | 12 | 09-24-2019 04:51 AM |
 Time to digital minutes
|
ogmium | Excel | 13 | 11-25-2016 03:26 AM |
|
Procedure for displaying symbols for degrees, minutes, seconds
|
kinglaird | Excel | 1 | 01-17-2015 02:04 AM |
Windows 10 
Office 2007
Threaded Mode