Period as separator in mins:secs time

masi · May 7th, 2002, 11:30 AM

I am working with data in the mm:ss format, minutes & seconds, never hours. Can I format cells and/or enter data using a period instead of a colon as the separator? And if so, how do I set this? Working with time in this manner is new for me. TIA. =)

Mark W. · May 7th, 2002, 12:50 PM

> Can I format cells using a period instead
> of a colon as the > separator? And if so,
> how do I set this?

Sure. Format as hh.mm if you like.

> Can enter data using a period instead of a
> colon as the separator?

If you change your Regional Settings. See the Excel Help Index topic for "Tips on entering dates and times".

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

May 7th, 2002, 11:30 AM	#1
masi New Member Join Date: May 2002 Posts: 1	I am working with data in the mm:ss format, minutes & seconds, never hours. Can I format cells and/or enter data using a period instead of a colon as the separator? And if so, how do I set this? Working with time in this manner is new for me. TIA. =)

May 7th, 2002, 12:50 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	> Can I format cells using a period instead > of a colon as the > separator? And if so, > how do I set this? Sure. Format as hh.mm if you like. > Can enter data using a period instead of a > colon as the separator? If you change your Regional Settings. See the Excel Help Index topic for "Tips on entering dates and times".