Forum Discussion
Working time formula
Hi, I need to write a formula to work out the average working time for staff over a 17 week(119 days) period. But if they use 'leave' then I must discount this day and add on the next working day...
Help us help you by uploading a sample of the actual worksheet that you have so far. Otherwise, we'd need to create our own, if only to test any recommendation.
Does this help? mathetes