Forum Discussion
Overtime, Normal Time Calculations
Hi all, full disclosure i'm pretty new to this. What i'm trying to do is two steps. One is to calculate the total hours worked per job which is calculated from three columns, travel start time, tra...
Does this help?
I have used IF functions to determine whether the hours of work fall between Normal Time hours (7am-3:30pm) or Overtime Hours (Any other time including weekends).
Below is just one example I have made for demonstration purposes
Hi, GrakeBliffin
Can you explain the calculate logic because you have three date columns?
In addition, The measure will change according to the context, we don’t know what kind of result you want.
I believe your problem is not difficult to solve.
Can you share some sample data(table format or a file instead of screenshot) and your desired result(in powerbi)? So we can help you soon.
Best Regards,
Community Support Team _ Janey