Forum Discussion

GrakeBliffin's avatar
GrakeBliffin
New Member
4 years ago

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...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

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's avatar
    GrakeBliffin
    New Member
    4 years ago

    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's avatar
      v-janeyg-msft
      Community Support
      4 years ago

      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