Paul Naylor
Board Regular
- Joined
- Sep 2, 2016
- Messages
- 98
- Office Version
- 365
- 2003 or older
- Platform
- Windows
- Mobile
- Web
Hi All,
Extracted data ( times ) from a text file , but although I've changed the format to time (hh:mm:ss) and adjusted the format of the sum to [hh]:mm:ss it won't give me the correct figure . Below is one of the columns (P5:P73). Formula for Sum ...=Sum(P5:P73) . Figure should he at least 13 and coming out at 3:10:42( figure in last cell). Anyone any idea what the issue is ?
Extracted data ( times ) from a text file , but although I've changed the format to time (hh:mm:ss) and adjusted the format of the sum to [hh]:mm:ss it won't give me the correct figure . Below is one of the columns (P5:P73). Formula for Sum ...=Sum(P5:P73) . Figure should he at least 13 and coming out at 3:10:42( figure in last cell). Anyone any idea what the issue is ?
:02:02 |
:02:53 |
:00:35 |
:03:16 |
:02:41 |
:04:11 |
:31:16 |
:02:10 |
:01:41 |
:03:30 |
:02:42 |
:30:13 |
:03:10 |
:02:58 |
:07:56 |
:02:42 |
:22:18 |
:02:05 |
:50:24 |
:04:26 |
:34:57 |
:03:58 |
:04:34 |
:04:16 |
:08:06 |
01:32:14 |
:05:58 |
:04:07 |
:25:07 |
:22:25 |
:14:34 |
:05:02 |
:25:59 |
:19:25 |
:00:12 |
:07:17 |
:15:49 |
:51:12 |
:38:03 |
:05:50 |
:05:33 |
:26:43 |
:00:00 |
:00:00 |
:01:43 |
:00:00 |
:01:43 |
:08:37 |
:02:09 |
:09:44 |
01:38:28 |
:02:28 |
:00:00 |
:01:50 |
:13:26 |
:00:00 |
:00:00 |
:00:00 |
:00:00 |
:00:00 |
:00:53 |
:02:26 |
:01:43 |
:01:52 |
:02:26 |
:03:36 |
:00:02 |
:02:14 |
:05:49 |
3:10:42 |