Free tool
Hours variance calculator: logged hours against planned time
Type the planned time and the hours logged on your orders and you will see the variance on each one and in total. The sums are done in your browser: nothing is sent and nothing is stored.
Work out the variance
One row per order. Hours can be typed with a point, with a comma or as hours and minutes: 12.5, 12,5 and 12:30 all mean the same.
The sums are done in your browser: nothing is sent and nothing is stored.
How it is calculated
- Variance in hours
- Hours logged minus planned time. If it is positive, the order took more hours than planned.
- Variance in %
- Variance in hours divided by planned time, times a hundred.
- Cost of the variance
- Variance in hours times the cost per hour, if you give one.
An example: an order with 12.0 h of planned time and 13.5 h logged has a variance of +1.5 h, which is +12.5%. If an hour cost €40, that would be €60 the quote did not allow for.
What to do with the result
One variance on its own says little. What matters is the pattern: if every order of one kind runs over, the planned time may be wrong; if the same section always runs over, the problem may be in the process or the setup.
To see that, you need the hours by order and by section, and you need them the same day. That is what Vexyon does: the shop floor clocks in at the machine and the comparison recalculates with every entry. How production control works.
Frequently asked questions
Is the data I type sent anywhere?
No. The calculator runs entirely in your browser: it makes no requests and stores nothing. When you close the page, the data is gone.
What does a negative variance mean?
That the order was made in fewer hours than planned. That is worth a look too: if it happens often, the planned time may be too generous.
Can I type minutes?
Yes. Typing 12:30 is read as 12.5 hours.