calculate days between two dates excluding weekends / calculate hours between two dates but only business hours

[wingers]

Does anyone have a function to do both of the following:-

1) Calculate number of days between two dates but excluding weekends (and possibly bank holidays)


2) Calculate number of hours between two dates but only including business hours of 09:00 - 17:00


This is to calculate SLA for help desk

So will have start_datetime and end_datetime


Darren Rose

Continue reading...