CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: how to calculate the time of the open ticket with regard to working hours

  1. #1
    Join Date
    Aug 2016
    Posts
    2

    how to calculate the time of the open ticket with regard to working hours

    I need calculate the time of the open ticket with regard to working hours & weekends. For example I have opened ticket time 2016-07-28 16:15, working hours is from 08:00 to 17:00. Have anyone ideas?

  2. #2
    PeejAvery's Avatar
    PeejAvery is offline Super Moderator Power Poster
    Join Date
    May 2002
    Posts
    10,943

    Re: how to calculate the time of the open ticket with regard to working hours

    Make sure date('N') is > 1 and < 7. That will get you week days. Then just count the max hours/minutes involved.
    If the post was helpful...Rate it! Remember to use [code] or [php] tags.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)