Skip to Content
Former Member
Feb 07, 2012 at 03:51 PM

duration between working days


Hi !

Need your help on this one,

I need to calculate the duration since the opening ticket until currentDateTime but considering the service hour ex:

Service hours is sunday to saturday from 8h00 to 21h00 so 46800 sec per working days

Ticket opening is from 2012-02-03 09:00:00 to currentdatetime (ex:11h), = 2days,6hours,0min,0sec

I will appreciate if someone can help me on this one, I 've already spent a lot of time on this one,but now i'm a little confused

Thanks in advance