narayanan_olam
New Member
How should I calculate working hours between two dates? Say if start at 26 Mar at 1:00pm and finish at 27 Mar at 10:00am, the function should return 6 hours because the working hours are from 5am to 2pm (8 - 17).
Preferably the function should work like the NETWORKDAYS() function, but it should also include the time, not just the dates. And also, if have to add say 8 hours to a date, how should I calculate the result? Also this function should aware of the working hours and holidays, so it should ignore those times. Weekends should also be excluded.
Preferably the function should work like the NETWORKDAYS() function, but it should also include the time, not just the dates. And also, if have to add say 8 hours to a date, how should I calculate the result? Also this function should aware of the working hours and holidays, so it should ignore those times. Weekends should also be excluded.
