|
|
#1
12-13-2024, 06:48 AM
|
|||
|
|||
How to input correctly time in minutes and seconds
Hi all again!
I need to input time in minutes and seconds, example 12 min and 33 secs. If I input in the cell 12:33, Excel takes as 12 hours and 33 minutes. I realized that if I need to input 12 min and 33 secs, I must input 0 hours too. 00:12:33  What is the reason? Thanks! 
|
|
#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.
|
|
#3
12-15-2024, 05:06 AM
|
|||
|
|||
|
Well, I was looking for this explanation on the net but I didn't find.
Thank you for the confirmation! 
|
|
|
|
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 XP 
Office 2010 32bit
Linear Mode
