Posted to microsoft.public.excel.misc

external usenet poster

Posts: 26

Formatting time

Hi,
I have a spreadsheet that imports time from another program and looks
somewhat like this:
Staffed Time Other Time ACW Time
105:46:14 4:35:20 1:23:07
8:00:12 :07:11 :28:03
8:17:21 :24:10 :00:00
8:44:13 :09:49 :07:19
8:03:23 :27:01 :06:19
8:14:35 :19:11 :00:00
7:59:48 :05:44 :12:35
7:51:47 :25:02 :00:00
8:04:09 :14:28 :09:16
8:12:44 1:08:00 :19:35
7:58:51 :12:13 :00:00
8:01:02 :17:54 :00:00
8:13:17 :07:53 :00:00
8:04:52 :36:44 :00:00

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 Formatting	Liz J[_2_]	Excel Discussion (Misc queries)	4	January 8th 09 06:57 PM
Formatting Time	Dan D...	Excel Worksheet Functions	7	August 30th 08 04:53 AM
Time Formatting	Fat Bloke	Excel Discussion (Misc queries)	4	September 2nd 07 01:38 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	4	November 18th 04 03:24 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	0	November 18th 04 03:13 PM

All times are GMT +1. The time now is 04:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us