Working hours

[powertechbi]

Good morning.

I have a database with equipment repair information.

I have the information: repair start date, repair end date, repair start time and repair end time.

I need to create a column that gives me the total working hours between these dates. In this case, excluding Saturdays and Sundays. Working hours are between 8 am and 5 pm.

Could anyone help me?

Thank you in advance.

[Ritaf1983 · Accepted solution]

Hi @powertechbi 
Please refer to the linked video, a very simple guide exactly for your scenario:
https://www.youtube.com/watch?v=6JA6uy3ZRBA

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.