Posted to microsoft.public.excel.worksheet.functions

Erin

external usenet poster

Posts: 75

Time Format Help Needed (Excel)

I am working with data in Excel and have time stamps in the format of 24hr
time but it does not have a colon. For example 1321 or 843 instead of what I
want 13:21 or 8:43.

Is there a way to either add a colon or change the format into a time
format. (I already tried just highlighting to change the format to time; it
doesn't work.)

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 format help needed	Dan W.	Excel Worksheet Functions	19	March 6th 08 09:08 AM
time guru needed	[email protected]	Excel Worksheet Functions	2	January 24th 08 01:12 PM
Converting a time format to a String format in Excel	Bill Partridge	Excel Discussion (Misc queries)	3	October 3rd 07 11:48 AM
IF / Else Format help needed	Paul B.	Excel Worksheet Functions	5	January 5th 06 06:37 PM
How to format cells in Excel for time in format mm:ss.00	Very Timely	Excel Worksheet Functions	0	March 30th 05 07:35 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us