Forum Discussion
Solved
Calculate total working hours between date/time excluding weekends and break time
Hello, I want to calculate the hours between two fields, but I just want a simple number of hours. No concatenated labels, not days, just accumulated hours and I need it to exclude weekends and...
I attached the wrong version, sorry.
The 2 hours in the first example is because the 1st of May is in the holiday list. If you remove that date from the holiday list, you get 3 hours.
See the attached version.
VladLockhart My issue is with Excel spreadsheet database which is separated by commas and I would like to revert back to a simple column and cell based view ? How c
an I do that ?