Discussions

 View Only
Expand all | Collapse all

Show Total # of Hours in Workdate duration

  • 1.  Show Total # of Hours in Workdate duration

    Posted 07-25-2017 17:33
    Hello,
    I'm trying to get a numeric value that represents the number of hours within a time frame set by two workdates. 

    The workdate fields are name Start and Finish. The field I am trying to create is called Hours Needed.

    I tried ([Start]-[Finish]*8) and got the error message that workdates can't use the (-) function. The '8' is the number of hours in a work day.

    I tried ToDate([Start])-ToDate([Finish])*8), and received no error message, but this included the 16 hours for Saturday and Sunday.

    An ideal result would be: If an assignment runs from 8/1 to 8/30, the Hours Needed value would be 184 (23 work dates in August, multiplied by 8 working hours).


    Any ideas?

    Thanks!


  • 2.  RE: Show Total # of Hours in Workdate duration

    Posted 07-31-2017 19:08
    Try this:

    WeekdaySub( [Finish], [Start]) * 8