Forum Discussion
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.
Hi powertechbi
Please refer to the linked video, a very simple guide exactly for your scenario:
https://www.youtube.com/watch?v=6JA6uy3ZRBAIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
1 Reply
- Ritaf1983Super User
Hi powertechbi
Please refer to the linked video, a very simple guide exactly for your scenario:
https://www.youtube.com/watch?v=6JA6uy3ZRBAIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.