Show Total # of Hours in Workdate duration

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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!
Photo of Heather Bryant

Heather Bryant

  • 972 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Michelle

Michelle

  • 230 Points 100 badge 2x thumb
Try this:

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