Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Aggregating time for hours worked

 I have data in Date/Time form. It is also sperated to In times and Out times. For a specific day, an employee can badge in and out multiple times (lunch, breaks, etc.). What I need is a total per day of someones hours worked. Ex( Badge in at 6:41:33Am, out at 11:48:37Am, in at 12:58:53 Am, and out at 4:04:03Pm giving me about 8 hours and 12 minutes worked. I am totally lost when it comes to date times. 

 

I am thinking of breaking up the date time field into one that is a date field and one that is a time field. Purely for my visual.

Need Help

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous ,

    In Power Query add a column out - in and change the type to duration.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

     

     

     

     

     

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    hi, Anonymous 

    You could use ([Out time]-[In time]) directly.

    Then you could format the result

    or use FORMAT to custom the result.

    If not your case, please share your expected output.

     

     

    Best Regards,

    Lin