Skip to main content
Participating Frequently
Apr 10, 2025 7:33 PM UTC
Question

time calculation between two dates for business hours and business days

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
    Genius
    Apr 10, 2025 11:01 PM UTC
    Participating Frequently
    Apr 11, 2025 7:08 AM UTC

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

    stefanhelzle0001
    Brainy
    Apr 11, 2025 8:38 AM UTC

    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
    Apr 14, 2025 4:44 AM UTC

    Hi [mention:3c4006cb0b9f41cf807504b4ea4bd28a:e9ed411860ed4f2ba0265705b8793d05] 

    You can set the working hours from process calendar.

    Participating Frequently
    Apr 17, 2025 8:29 AM UTC

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