Hello All,
I need to calculate the hours of my vehicles. I have trackers but the information they give is just not quite what I need. the information they give me on a spreadsheet is in column C and is below. How can I use VBA to take the times in this case start at 09:57:38 and finish at 11:12:28 and in say cell A1 will be the total time taken. The tracker works on 24 hour clock and there is no set working weekday just dates etc.
I need to calculate the hours of my vehicles. I have trackers but the information they give is just not quite what I need. the information they give me on a spreadsheet is in column C and is below. How can I use VBA to take the times in this case start at 09:57:38 and finish at 11:12:28 and in say cell A1 will be the total time taken. The tracker works on 24 hour clock and there is no set working weekday just dates etc.
DateTime |
21/10/2020 09:57:38 |
21/10/2020 10:02:39 |
21/10/2020 10:07:39 |
21/10/2020 10:12:39 |
21/10/2020 10:17:39 |
21/10/2020 10:22:39 |
21/10/2020 10:27:40 |
21/10/2020 10:32:40 |
21/10/2020 10:37:31 |
21/10/2020 10:42:29 |
21/10/2020 10:47:27 |
21/10/2020 10:52:31 |
21/10/2020 10:57:32 |
21/10/2020 11:02:33 |
21/10/2020 11:07:30 |
21/10/2020 11:12:28 |
21/10/2020 11:17:31 |