Posted to microsoft.public.excel.misc

metaltecks metaltecks is offline

external usenet poster

Posts: 22

Time Question

I have field that is formatted as a general number. Ex. 2038
I need to have this number to show up as a time field. 20:38 or 10:38.

How can I do this?

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
Time Question	colin	Excel Discussion (Misc queries)	1	March 17th 06 12:37 PM
Time question	Anthony	Excel Discussion (Misc queries)	1	October 9th 05 05:15 PM
Time Question	SU	Excel Worksheet Functions	2	August 1st 05 12:20 PM
Time Question	Kelly Thompson	Excel Discussion (Misc queries)	8	December 30th 04 10:35 PM
Best time question	Daniel Bonallack	Excel Worksheet Functions	2	December 10th 04 11:37 PM

All times are GMT +1. The time now is 11:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us