Spreadsheet: 50256d1249632948-convert-hours-minues-and-seconds-to-time-decimal-sample-1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | New Start Time | New End Time | Time Difference | New Start Time | New End Time | Time Difference (Hours) | Time Difference (Minutes)
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 17:02:30 | 2009-07-31 19:47:40 | 02:45:10 | 2009-07-31 17:02:30 | 2009-07-31 19:47:40
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 19:46:24 | 2009-07-31 19:46:34 | 00:00:10 | 2009-07-31 19:46:24 | 2009-07-31 19:46:34
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 19:45:17 | 2009-07-31 19:45:28 | 00:00:11 | 2009-07-31 19:45:17 | 2009-07-31 19:45:28
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 19:46:05 | 2009-07-31 19:46:13 | 00:00:08 | 2009-07-31 19:46:05 | 2009-07-31 19:46:13
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 19:46:24 | 2009-07-31 19:46:34 | 00:00:10 | 2009-07-31 19:46:24 | 2009-07-31 19:46:34
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 19:45:45 | 2009-07-31 19:45:56 | 00:00:11 | 2009-07-31 19:45:45 | 2009-07-31 19:45:56
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 19:46:44 | 2009-07-31 19:46:50 | 00:00:06 | 2009-07-31 19:46:44 | 2009-07-31 19:46:50
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 19:46:44 | 2009-07-31 19:46:50 | 00:00:06 | 2009-07-31 19:46:44 | 2009-07-31 19:46:50
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 19:47:27 | 2009-07-31 19:47:35 | 00:00:08 | 2009-07-31 19:47:27 | 2009-07-31 19:47:35
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 19:46:59 | 2009-07-31 19:47:18 | 00:00:19 | 2009-07-31 19:46:59 | 2009-07-31 19:47:18
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 22:55:58 | 2009-07-31 22:56:10 | 00:00:12 | 2009-07-31 22:55:58 | 2009-07-31 22:56:10
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 22:56:18 | 2009-07-31 22:56:43 | 00:00:25 | 2009-07-31 22:56:18 | 2009-07-31 22:56:43
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 22:57:47 | 2009-07-31 22:57:58 | 00:00:11 | 2009-07-31 22:57:47 | 2009-07-31 22:57:58
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 22:58:02 | 2009-07-31 22:58:14 | 00:00:12 | 2009-07-31 22:58:02 | 2009-07-31 22:58:14
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 22:57:33 | 2009-07-31 22:57:42 | 00:00:09 | 2009-07-31 22:57:33 | 2009-07-31 22:57:42
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 22:58:16 | 2009-07-31 22:58:25 | 00:00:09 | 2009-07-31 22:58:16 | 2009-07-31 22:58:25
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 17:00:49 | 2009-07-31 22:58:30 | 05:57:41 | 2009-07-31 17:00:49 | 2009-07-31 22:58:30
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 00:30:02 | 2009-08-01 00:30:11 | 00:00:09 | 2009-08-01 00:30:02 | 2009-08-01 00:30:11
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 00:30:01 | 2009-08-01 00:30:11 | 00:00:10 | 2009-08-01 00:30:01 | 2009-08-01 00:30:11
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 15:10:57 | 2009-08-01 00:30:16 | 09:19:19 | 2009-07-31 15:10:57 | 2009-08-01 00:30:16
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 15:10:57 | 2009-07-31 15:10:58 | 00:00:01 | 2009-07-31 15:10:57 | 2009-07-31 15:10:58
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 17:03:39 | 2009-07-31 17:45:27 | 00:41:48 | 2009-07-31 17:03:39 | 2009-07-31 17:45:27
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 17:03:39 | 2009-07-31 17:03:39 | 1900-01-01 00:00:00 | 2009-07-31 17:03:39 | 2009-07-31 17:03:39
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 17:45:08 | 2009-07-31 17:45:08 | 1900-01-01 00:00:00 | 2009-07-31 17:45:08 | 2009-07-31 17:45:08
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 17:45:19 | 2009-07-31 17:45:19 | 1900-01-01 00:00:00 | 2009-07-31 17:45:19 | 2009-07-31 17:45:19
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 04:01:14 | 2009-08-01 04:01:22 | 00:00:08 | 2009-08-01 04:01:14 | 2009-08-01 04:01:22
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 04:06:24 | 2009-08-01 04:07:47 | 00:01:23 | 2009-08-01 04:06:24 | 2009-08-01 04:07:47
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 09:02:59 | 2009-08-01 09:03:09 | 00:00:10 | 2009-08-01 09:02:59 | 2009-08-01 09:03:09
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 03:07:18 | 2009-08-01 03:07:50 | 00:00:32 | 2009-08-01 03:07:18 | 2009-08-01 03:07:50
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 03:04:48 | 2009-08-01 03:05:04 | 00:00:16 | 2009-08-01 03:04:48 | 2009-08-01 03:05:04
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 01:01:51 | 2009-08-01 01:02:00 | 00:00:09 | 2009-08-01 01:01:51 | 2009-08-01 01:02:00
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 04:00:59 | 2009-08-01 04:06:20 | 00:05:21 | 2009-08-01 04:00:59 | 2009-08-01 04:06:20
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 04:00:46 | 2009-08-01 04:00:56 | 00:00:10 | 2009-08-01 04:00:46 | 2009-08-01 04:00:56
 |  |  |  |  |  |  |  |  |  |  | 2009-07-31 15:10:57 | 2009-08-01 09:03:09 | 17:52:12 | 2009-07-31 15:10:57 | 2009-08-01 09:03:09
 |  |  |  |  |  |  |  |  |  |  | 2009-08-01 00:30:16 | 2009-08-01 00:30:16 | 1900-01-01 00:00:00 | 2009-08-01 00:30:16 | 2009-08-01 00:30:16