Over Time Calculator

A Grist creator recently asked for help creating a workflow that calculates over time.

The company has salaried employees who are paid a regular rate each week for 40 hours of work. Any work in excess of 40 hours has a 1.5x multiplier. Those who manage the document need an easy way to see how many hours were worked each week, what was the regular rate paid, and the OT rate.

Here’s an example of how this could be calculated in Grist: Grist

There’s a video attached to the table in the WATCH VIDEO page that explains how the example works and the formulas used.