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, travel arrival time and completion time.
Then I need to split these hours into normal and overtime.
Normal Time is 7:00am to 3:30pm and OT any other time
Any help appreciated, or advice on youtube videos or resources that could get me going in the right direction
5 Replies
GrakeBliffin , Not very clear, But you need these column, some of them can be var in a new column
Arrival Time = datediff([Travel Start Time], [Arrival Time], Second)//you can use minute or hour
Actual Time = datediff([Travel Start Time], [CompletionTime], Second)//you can use minute or hour
compare these to
if([Actual Time] <= [Arrival Time], "Ontime", "Over Time")
why the start time and arrvial time are the same?
could you pls do the same calculation in excel and provide the screenshot?
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
