Subtracting Hours
I’m having trouble finding a solution to my problem.
I have a table with the following Headers NAME, DATE and HOUR METER VALUE.
There are about 1800 entries from about 12 different names. In the Hour Meter Column there are entries for the hours shown on a engine run time. So for instance:
Vehicle 1 1/3/2024 10015
Vehicle 1 1/2/2024 10013
Vehicle 2 1/2/2024 955
Vehicle 1 1/1/2024 10008
Vehicle 2 1/1/2024 945
What I need to do is find the difference between each entry and total them to find out total run time of the engines.
Vehicle 1 = 7 hours
Vehicle 2 = 10 Hours
Thanks for looking.
I’m having trouble finding a solution to my problem. I have a table with the following Headers NAME, DATE and HOUR METER VALUE. There are about 1800 entries from about 12 different names. In the Hour Meter Column there are entries for the hours shown on a engine run time. So for instance: Vehicle 1 1/3/2024 10015Vehicle 1 1/2/2024 10013Vehicle 2 1/2/2024 955Vehicle 1 1/1/2024 10008Vehicle 2 1/1/2024 945 What I need to do is find the difference between each entry and total them to find out total run time of the engines. Vehicle 1 = 7 hoursVehicle 2 = 10 Hours Thanks for looking. Read More