date/time addition

Hi maxkhan ,
Thank you for your response. Below is a detailed overview for your reference.
Add a New Column for the Actual Start Time of the Task

• Open Power BI Desktop and load your dataset,In the Power Query Editor go to the Add Column tab
• In dialog box, givea name to the new column . For example, enter ActualStartTime as the column name.
• In the formula area,enter the below code

= [ShiftStartTime] + #duration(0, 0, [ActualStartTimeOffset], 0)

Add a New Column for the Actual Duration of the Task

• Again, go to the Add Column tab. Click on Custom Column, name new column as ActualDuration.
• Use the following formula to calculate the duration in hours

= Duration.TotalHours([ActualEndTime] - [ActualStartTime])

Convert the Duration to an Integer Value

•  Go to the Add Column tab. Click on Custom Column.
• Name the new column as Duration In Integer.
• Use the below query

= Number.RoundDown([ActualDuration])

Hope the steps provided will be helpful in guiding you to create custom columns.If so,

please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!