Question
Timeshet calculation with multiple workers
I am trying to compute a form that my foreman can fill out onsite. I have 4 columns, Start, Finish, Number of Workers, and Total Time.
How can the total time column to give a sum of every ones hours.
example total hours = (Finish-Start)*Number of workers.
Something that yields like the table below.
Thanks
Josh
| Start | Finish | Number of workers | Total Time |
|---|---|---|---|
| 9:00 | 17:00 | 3 | 24 |
| 9:00 | 16:00 | 2 | 14 |
