Formatting Duration

[JonnyConc]

I have been given a download of data that details the length of time certain tasks take to complete (examples below), is there a 'simple' way in which I can format these rows of data so that they show the seconds or minutes for each?
21h 44m 38s
10m 1 sec
4 hrs 23m 34s
4m 18 secs
40m 42 secs
26m 37 secs
4 m 19 secs
1hr 17m 19secs
19 m 43 secs
11 m 36 secs

Cheers

[AlKey]

Try this
Enter in B1 and copy down. Format as Custom, [hh]:mm:ss

Please Login or Register  to view this content.

v	A	B
1	21h 44m 38s	21:44:38
2	10m 1 sec	00:10:01
3	4 hrs 23m 34s	04:23:34
4	4m 18 secs	00:04:18
5	40m 42 secs	00:40:42
6	26m 37 secs	00:26:37
7	4 m 19 secs	00:04:19
8	1hr 17m 19secs	01:17:19
9	19 m 43 secs	00:19:43
10	11 m 36 secs	00:11:36

[JonnyConc]

That's brilliant - thank you very much

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.