|
West Central Ohio | Prolly some experts here that will chime in with better ideas, but my first idea was to put "check" in your formula that would change the calculation (simple subtraction I assume) using an "if" statement if the result is outside some sort of expected range. So if in normal case the hours running is in some range of say 100 to 500 hours, if the result of the calculation is negative 7120 hours then you know the meter rolled over so you would use a modified formula that would take that into account. | |
|
Excel Question
