Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting time
Please disregard this post - I hit enter too early :)
"Marta" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting time
Yes, see your later post for my suggested answer.
Pete On Jul 28, 7:34*pm, Marta wrote: Please disregard this post - I hit enter too early :) "Marta" wrote: 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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Formatting | Excel Discussion (Misc queries) | |||
Formatting Time | Excel Worksheet Functions | |||
Time Formatting | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |