Forum Discussion
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 ...
MrB To calculate the overall net usage for each vehicle, simply use MAXIFS minus MINIFS:
=MAXIFS(hour_range, name_range, name) - MINIFS(hour_range, name_range, name)If additional scenarios are needed (ie: calculating daily usage or net usage for a specified period), please see the attached workbook, which also includes single cell dynamic array examples for MS365...
Both of the solutions provided worked perfectly. Thank you for responses.
