Posted to microsoft.public.excel.misc

Carole O

external usenet poster

Posts: 69

Entering HH:MM

Excel 2003

I have a co-worker who enters time on a spreadsheet. She would like to have
the time cells fomatted so when she enters 1456 it appears in the cell as
14:56. This doesn't work when I format, cell, time, 13:30. I've looked at
format, cell, special (which would be a logical place to put something like
this), to no avail.

TIA
CaroleO

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
entering dates	Ed	Excel Discussion (Misc queries)	1	November 26th 06 05:42 PM
entering numbers	Kendra	Excel Discussion (Misc queries)	1	July 5th 06 09:51 PM
entering numbers	vjc	Excel Discussion (Misc queries)	2	June 10th 06 08:21 PM
102. not entering the same as 102.00	Stacy	Excel Discussion (Misc queries)	8	December 2nd 05 06:02 PM
entering data using tab	Karen Boyd	Excel Discussion (Misc queries)	1	October 21st 05 12:00 AM

All times are GMT +1. The time now is 07:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us