Posted to microsoft.public.excel.worksheet.functions

Chris

external usenet poster

Posts: 788

Help with Time Function

I have a list of a few thousand times in this 24 hour format:

14:54:12
04:50:46

I need to convert all to 12 hour format rounded to the nearest minute,
example:

14:54:12 would be 2:54 PM
04:50:46 would be 4:51 AM

I am totally lost and dread having to convert thousands by hand, but that's
the exact format the job requires. Any help is greatly appreciated.

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
Function time	May	Excel Worksheet Functions	1	September 17th 07 04:31 PM
Time function	vito	Excel Worksheet Functions	2	August 10th 07 04:38 PM
verify use of TIME Function, Find Quantity Level compare to time-d	nastech	Excel Discussion (Misc queries)	9	July 11th 07 01:58 PM
Time VBA or NOW function	Jenny B.	Excel Discussion (Misc queries)	2	June 22nd 07 03:22 PM
Function to convert Time String to Time	Andibevan	Excel Worksheet Functions	6	August 19th 05 01:19 PM

All times are GMT +1. The time now is 06:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us