hello,
I've got a worksheet with data below. As you can see, the data is in hour: min: sec format.(eg: C6=1h 16m 34s). I want this data to be converted into the format 01:16:34. Could this be done with the help of a macro? any suggestion would be greatly appreciated. thanks
someone pls help...i'm desperate
This message was edited by catch22 on 2002-11-07 05:02
I've got a worksheet with data below. As you can see, the data is in hour: min: sec format.(eg: C6=1h 16m 34s). I want this data to be converted into the format 01:16:34. Could this be done with the help of a macro? any suggestion would be greatly appreciated. thanks
Book3 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | M | T | W | T | F | S | S | M | T | W | ||
2 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | ||
3 | -- | -- | 9s | 8s | 7s | -- | 8s | -- | -- | 9s | ||
4 | -- | -- | 17m 28s | 25s | -- | 12s | 7s | -- | -- | 5s | ||
5 | -- | -- | 33m 8s | 6s | 22s | 8s | 7s | 43s | 10s | 8s | ||
6 | -- | -- | 1h 16m 34s | 7s | 8s | 12s | 13s | 9s | 5s | 9s | ||
7 | -- | -- | 1h 4m 32s | 2m 38s | 5s | 13m 27s | 8s | 7s | 2m 51s | 9s | ||
8 | -- | -- | 1h 1m 13s | 2m 15s | -- | 2m 54s | 54s | 11m 25s | 8s | 2m 6s | ||
9 | -- | -- | 1h 7m 32s | 16m 31s | 9s | 4m 31s | 13m 26s | 19m 13s | 7s | 2m 52s | ||
10 | 9m 54s | -- | -- | 13s | 24s | 2m 43s | 6m 44s | 2m 42s | 3m 27s | 7s | ||
11 | -- | -- | 10s | 14s | 13s | 11m 26s | 1m 4s | 57s | 2m 29s | 1m 5s | ||
12 | -- | -- | 23s | 2m 38s | 7s | 8m 22s | 13m 8s | 30s | 4m 15s | 1m 43s | ||
13 | 18s | 9s | 14s | 3m 11s | 54s | 4m 33s | 4m 8s | 8s | 8s | 56s | ||
14 | 16s | 9s | 9s | 7s | 8s | 15s | 8s | 14s | 10s | 12s | ||
15 | 12s | 36s | 9s | 9s | 15s | 8s | 10s | 8s | 9s | 8s | ||
16 | 14s | 12s | 11s | 10s | 9s | 10s | 17s | 9s | 8s | 9s | ||
17 | 10s | 11s | 8s | 8s | 6s | 9s | 12s | 13s | 10s | 10s | ||
18 | 13s | 12s | 9s | 11s | 8s | 9s | 11s | 9s | 8s | 14s | ||
19 | 12s | 11s | 8s | 7s | 7s | 6s | 14s | 10s | 11s | 6s | ||
Sheet1 |
someone pls help...i'm desperate
This message was edited by catch22 on 2002-11-07 05:02