Show Total # of Hours in Workdate duration
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!
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!
