Overtime, Normal Time Calculations

[GrakeBliffin]

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

[ryan_mayu]

@GrakeBliffin 

why the start time and arrvial time are the same?

could you pls do the same calculation in excel and provide the screenshot?

[GrakeBliffin]

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

[v-janeyg-msft]

@GrakeBliffin  Any updates? 

[v-janeyg-msft]

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

[amitchandak]

@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")