💻 Software
Entering Time data in excel in mm:ss format (without the leading 0: for the hours)
Fresh5 days ago
Mar 15, 2026223631 viewsConfidence Score0%
0%
Problem
I want to enter time data into excel sheet in mm:ss format. The problem is - that although the cell format is mm:ss, if I enter the data like this: 12:33 the actual value stored is 12 hours and 33 min. if I want 12 min and 33 sec, I need to enter 0:12:33 Is there a way to make the cell accept 12:33…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Entering Time data in excel in mm:ss format (without the leading 0: for the hours)
Low Risk
As answered by Steve, Excel interpret user input as 12h33m. You cannot change this behavior of how Excel accepts user input. As you mentioned in comment, users would input but meaning 12m33s. Here is an workaround solution to get the correct value f…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix