Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ErickGaitan
Frequent Visitor

Sum hours for night shift employees

Solution: https://community.powerbi.com/t5/Desktop/Shift-that-Goes-into-Next-day/m-p/2690043#M941771

 

Good day community,

I need help, I am trying to sum the total amount of hours worked by each employee, to measeure the complaince, the have a certain amount of hour scheduled. My problem is that could not sum accuratly the hour work by the graveyard agent: They usually start shift at 6.00 pm, 7.00 pm or 9.00 pm. They end the shift the next day but the hours should count in the previous day; which is the nominal day, is there any way to make this possible?

 

IntervalHours
9/1/2022 0:001800
9/1/2022 0:001800
9/1/2022 0:001800
9/1/2022 0:001800
9/1/2022 0:001800
9/1/2022 0:001800
9/1/2022 0:001800
9/1/2022 0:001800
9/1/2022 0:001800
9/1/2022 0:301800
9/1/2022 0:301800
9/1/2022 0:301800
9/1/2022 0:301800
9/1/2022 0:300
9/1/2022 0:300
9/1/2022 0:300
9/1/2022 0:300
9/1/2022 0:300
9/1/2022 1:000
9/1/2022 1:000
9/1/2022 1:000
9/1/2022 1:000
9/1/2022 1:000
9/1/2022 1:001800
9/1/2022 1:001800
9/1/2022 1:001800
9/1/2022 1:001800
9/1/2022 1:301800
9/1/2022 1:301800
9/1/2022 1:301800
9/1/2022 1:301800
9/1/2022 1:301800
9/1/2022 1:301800
9/1/2022 1:301800
9/1/2022 1:301800
9/1/2022 1:301800
9/1/2022 20:001800
9/2/2022 20:301800
9/3/2022 21:001800
9/4/2022 21:301800
9/5/2022 22:001800
9/6/2022 22:301800
9/7/2022 23:000
9/8/2022 23:300
9/10/2022 0:000

 

 

7 REPLIES 7
Tony_Kuiper
Helper I
Helper I

Like Dinesh suggests... if your data was :

emp_id, start_time, finish_time

abc, 01/01/2022 18:00, 02/01/2022 07:00

etc your data would be more "friendly" to work with.

Tony_Kuiper
Helper I
Helper I

Personally I would look at capturing the start date/time and the end date/time only per user. The difference between the stamps will give you the hours. You can use the start date (trimmed to date) as the label for the work shift. You need a lot less data than what you appear to have there.

Dinesh_Suranga
Responsive Resident
Responsive Resident

@ErickGaitan ,

Hi,

Do you have columns for start time and end time?

Thank you

I usually split the columns to get the date and the intervals

@ErickGaitan 

Hi,

Does this Interval column show start day or end day?

ex in 1st row it shows 9/1/2022 0:00. Is this start day or end day?

Thank you.

9/1/2022 0:00 this is the start day, it is the first segment of the day, what i am looking for is sum the hours based on the nominal day, when they started the shift

@ErickGaitan 

Hi,

Please share some sample data of your table.

Thank you.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.