Data360 Analyze

 View Only
  • 1.  How to modify Calculate WorkDays node to calculate work hours

    Employee
    Posted 12-16-2019 08:57
    How to modify Calculate WorkDays node to calculate work hours


  • 2.  RE: How to modify Calculate WorkDays node to calculate work hours

    Employee
    Posted 12-18-2019 03:59

    There was no body text included in you post. Were you using Internet Explorer? The support portal's software vendor, Zendesk, is progressively withdrawing support for Internet Explorer so this may be the root cause if you had tried to post some content.

    However, extrapolating from the title of your post: The purpose of the Calculate Workdays node is to calculate the number of whole workdays between two dates. The node itself cannot be modified to generate working hours but if you have a standardized number of hours in a work day then you can simply use a Calculate Fields node to generate the number of hours:



  • 3.  RE: How to modify Calculate WorkDays node to calculate work hours

    Employee
    Posted 12-19-2019 08:59

    Yes, I had used Internet Explorer.

    Thanks for your answer. I think I can use my Excel formulas to workaround calculating the hours. I need to get the Calculate Workdays node working first. My start date and end date have date formats but it just doesn't run. Any ideas?



  • 4.  RE: How to modify Calculate WorkDays node to calculate work hours

    Employee
    Posted 12-19-2019 09:02

    nvm I just deleted and recreated the node and it worked.