Actual Hours Issue | Community
Skip to main content
V
Vin01
New Participant
November 8, 2022
Solved

Actual Hours Issue

  • November 8, 2022
  • 1 reply
  • 745 views

I'm trying to pull hours & minutes between actual start and actual completion on an issue. I see a field for "Actual Hours", but it pulls all zeros. Is there a code to pull hours/minutes between start/end? I've tried

 

displayname=Act Time Taken
linkedname=direct
textmode=true
valueexpression=WORKHOURSDIFF({actualStartDate},{actualCompletionDate})
valueformat=HTML

 

also w/

valueexpression=WEEKDAYDIFF({actualStartDate},{actualCompletionDate})

 

 

Thanks,

Vin

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

Thank you Richard! I think this will work. I noticed some issues returned 0 because the start/end time was outside working hours (since it can be a user globally).So going to see how to calculate those without capturing full 24 hours for other issues.

1 reply

R
Richard_Le_
New Participant
November 8, 2022

Hi Vin,

 

Try WORKMINUTESDIFF instead, then divide by 60 to get the number of hours. The below textmode should do it

 

valueexpression=ROUND(DIV(WORKMINUTESDIFF({actualCompletionDate},{actualStartDate}),60),2)

Best Regards,

Rich. 

V
Vin01AuthorAccepted solution
New Participant
November 9, 2022

Thank you Richard! I think this will work. I noticed some issues returned 0 because the start/end time was outside working hours (since it can be a user globally).So going to see how to calculate those without capturing full 24 hours for other issues.

R
Richard_Le_
New Participant
November 9, 2022

No problem Vin. If this solved your problem, please mark it as a Correct Answer so that others know that the solution works.

Terms & ConditionsAccessibility statement

Loading footer...