Count only hours during Weekdays | Community
Skip to main content
Level 4
March 6, 2024
Question

Count only hours during Weekdays

  • March 6, 2024
  • 1 reply
  • 416 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
Community Advisor
Community Advisor
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.