Skip to main content
New Participant
March 6, 2024
Question

Count only hours during Weekdays

  • March 6, 2024
  • 1 reply
  • 414 views

Hi WF Community.

 

I just want to consult the text mode below. How do I exclude the weekends from this report? I tried to use WEEKDAYDIFF, but the result is not what I'm looking for. It will only display hours greater than or equal to 24 hours, but if it is less, it will only show 0.

 

description=Aging Tickets
displayname=Aging Hours
textmode=true
valueexpression=IF({status}="INP",ABS(ROUND(DATEDIFF($$TODAY,{entryDate}),2))*24,IF({status}="NEW",ABS(ROUND(DATEDIFF($$TODAY,{entryDate}),2))*24,ABS(ROUND(DATEDIFF({actualCompletionDate},{entryDate}),2))*24))
valueformat=HTML

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

KellieGardner
New Participant
March 6, 2024

@a_en - WEEKDAYDIFF is going to include timestamps which could skew the data. You might need to combine a CLEARTIME with WEEKDAYDIFF to get it to work.