Time Scheduled: calculating time between time stamps

Power BI
1

I am trying to calculate total hours scheduled by subtracting the time-Out(s) from the Time-in(s) (i.e. 8 hour shift with a 30 minute lunch) If you can reformat the column to be a number rather then a time I can not seem to find that as an option.

image
image1007Ă—152 13.2 KB

2

Hello @bsteinacher,

Thank You for posting your query onto the Forum.

Well you can simply use the “DATEDIFF” function to calculate the Time Scheduled. Below is the screenshot provided for the reference -

Time Scheduled - 1
Time Scheduled - 1838Ă—424 83.9 KB

Time Scheduled - 2

I’m also attaching the Excel as well as PBIX file of my working for the reference.

Hoping you find this useful and helps you in your analysis. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Time Scheduled.xlsx (9.0 KB)

Time Scheduled.pbix (42.0 KB)

1 Like
3

Thank you. Works great.

4

Hello @bsteinacher,

You’re Welcome. :slightly_smiling_face:

I’m glad I was able to help you.

Thanks and Warm Regards,
Harsh