DevonLeukes
New Member
- Joined
- May 6, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi
I am trying to write either a VBA code or just apply a formula (if possible) to determine how many hours a vehicle has left before the next service is due. The idea is that the user will enter the hour reading on the vehicle daily at the beginning of the shift and the output will be an indication of how many hours is available before the next service.
Criteria is as follows:
1. Between 0 and 1000hrs a service is required every 500hrs
2. Above 1000hrs a service is required every 250hrs
It should look something like below where the "hours to next service" is calculated
I am trying to write either a VBA code or just apply a formula (if possible) to determine how many hours a vehicle has left before the next service is due. The idea is that the user will enter the hour reading on the vehicle daily at the beginning of the shift and the output will be an indication of how many hours is available before the next service.
Criteria is as follows:
1. Between 0 and 1000hrs a service is required every 500hrs
2. Above 1000hrs a service is required every 250hrs
It should look something like below where the "hours to next service" is calculated
| Forklift 1 | Forklift 2 | ||
| Total running hours | 200 | 1400 | input by user |
| Hours to next service | 300 | 100 | output required |
