Posted to microsoft.public.excel.misc

Mike

external usenet poster

Posts: 3,101

Entering a time into excel

I am trying to enter a time in military time ie: 1500 for 3:00 PM. Everytime
it puts 0:00. I have tried formatting the cell everyway possible. I don't
need a date stamp just the time for time cards. I would like the end result
to display standard time 3:00 PM. Any help would be greatly apreciated.

Thanks in advance.
Mike

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 time	C	Excel Worksheet Functions	1	June 10th 09 05:10 PM
Entering TIME into excel...	SooHunter	Excel Worksheet Functions	2	February 7th 08 08:10 PM
In Excel: Time Entering	Reno747	Excel Worksheet Functions	2	November 30th 07 09:29 PM
Entering time	Chris	Excel Discussion (Misc queries)	4	June 27th 07 04:50 AM
entering negative time values in excel	dona	Excel Discussion (Misc queries)	5	March 13th 06 08:23 AM

All times are GMT +1. The time now is 09:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us