Skip to main content
Participating Frequently
April 10, 2025
Question

time calculation between two dates for business hours and business days

  • April 10, 2025
  • 13 replies
  • 13 views

I have a working hours set to 8:30 AM to 7PM EST, it should calculate only these hours for business days and remaining non working hours or non business days should not calculate.

Example: requests submitted only calculate from monday-friday 8:30 AM to 7:00 PM ET.

  • A request created on sunday 3PM. the clock starts at monday 8:30 AM
  • A request created on Tuesday 6:45 PM. the clock starts at tuesday 6:45 PM/ pauses at tuesday 7:00 PM/ resumes at wednesday 8:30 AM.

Earlier we had a plugin called calendar functions but now its archived, is there any other alternative way to do? 

    13 replies

    mathieud0001
    Brainy
    April 10, 2025
    Participating Frequently
    April 11, 2025

    calworkhours calculate only 9AM to 5PM ET, but i need to calculate 8:30 AM to 7PM

    stefanhelzle0001
    Brainy
    April 11, 2025

    You wrote above "I have a working hours set to 8:30 AM ". What exactly do you mean by that? Where did you "set" this?

    Participating Frequently
    April 14, 2025

    Hi [mention:3c4006cb0b9f41cf807504b4ea4bd28a:e9ed411860ed4f2ba0265705b8793d05] 

    You can set the working hours from process calendar.

    Participating Frequently
    April 17, 2025

    I did that, it should calculate minutes not hours, calworkhours() will give hour difference not minutes right?