Forum Discussion
Multiple IF Condition and return value
Hi Anonymous
Another approach which I find it more feasible is to have a dimension table of the standard working times. Here is a sample file https://www.dropbox.com/t/Dd02knQPHCaqUbRYYou can also apply the same to the duty finish time. I guess your ultimate goal is to calculate the hours worked ignoring early clockin and late clockout. You can calculate both values and store them in variables and then calculate the difference directly without having to create unnecessary new columns.
Both measure and calculated column options are provided in the solution.
Community ChampionHi Anonymous
Another approach which I find it more feasible is to have a dimension table of the standard working times. Here is a sample file https://www.dropbox.com/t/Dd02knQPHCaqUbRY
You can also apply the same to the duty finish time. I guess your ultimate goal is to calculate the hours worked ignoring early clockin and late clockout. You can calculate both values and store them in variables and then calculate the difference directly without having to create unnecessary new columns.
Both measure and calculated column options are provided in the solution.
Super UserAlso you can create this table in Google Spreadsheets and connect it with Power Apps.
Then add Power Apps to your dashboard.