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
  • 424 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 and Adobe Champion
Community Advisor and Adobe Champion
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.