Forum Discussion
Anonymous
8 years agoNot applicable
Capacity Reporting with Employee Work Hours
I want to show in a visual that an employee worked a certain amount of hours on a given date; and also show if it was above or under capacity for the day. I want this visual to be used for the week...
Ashish_Mathur
8 years agoSuper User
Hi,
In a calculated column, you can write a simple Overtime formula
=MAX([Work hours]-[Capacity by day],0)
Hope this helps.