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
Super User
8 years agoHi,
In a calculated column, you can write a simple Overtime formula
=MAX([Work hours]-[Capacity by day],0)
Hope this helps.