Posted to microsoft.public.excel.worksheet.functions

Ellen

Posts: n/a

Time formatting:data 1:30:20 entered reads in 1:30:20 pm

I am trying to get data entered in format 1:30:25 etc... to read 1:30:25 PM
but it keeps reverting back to am.

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
Accumulate weekly time to total time in Excel.	delve	Excel Discussion (Misc queries)	0	May 4th 05 08:14 PM
I need a time sheet template that verifies time entered against sy	Bob Powell	Excel Discussion (Misc queries)	1	April 19th 05 03:11 PM
unmet challenge	boris	Excel Worksheet Functions	2	March 16th 05 02:13 PM
Help - Information with time and date	PM	Excel Discussion (Misc queries)	4	January 6th 05 08:25 AM
Employee schedule: I want it to calculate time entered such as 11.	Atlanta Rudy	Excel Discussion (Misc queries)	2	January 6th 05 05:19 AM

All times are GMT +1. The time now is 04:10 AM.

About Us

"It's about Microsoft Excel"