How to input correctly time in minutes and seconds

		Microsoft Office Forums > Microsoft Excel > Excel
How to input correctly time in minutes and seconds

FAQ

Mark Forums Read

Thread Tools

Display Modes

12-13-2024, 06:48 AM

massimodfd massimodfd is offline

Windows XP How to input correctly time in minutes and seconds

Office 2010 32bit

Novice

Join Date: Jan 2015

Posts: 29

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!

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:53 PM.