Hello again guys!
Today I have a really unusual task. =)
I have 2 date columns - start date and finish date accordingly.
I want to calculate a mathematical difference between these dates in a third column, but without taking free (non working) time into consideration.
For instance, if start date is something like 3 pm friday and finishing date is 12 am monday then having an eight-hours working day we will get 7 working hours.
If it's too difficult as a last resort we could just not count Saturday and Sunday.
Today I have a really unusual task. =)
I have 2 date columns - start date and finish date accordingly.
I want to calculate a mathematical difference between these dates in a third column, but without taking free (non working) time into consideration.
For instance, if start date is something like 3 pm friday and finishing date is 12 am monday then having an eight-hours working day we will get 7 working hours.
If it's too difficult as a last resort we could just not count Saturday and Sunday.
Last edited: