Forum Discussion

powertechbi's avatar
powertechbi
Frequent Visitor
1 year ago
Solved

Working hours

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.