Hi, I'm trying to get the time spent on a work item. Like, if I activated the user story/task at 15:30 and closed it at 15:44, I would have spent 14 minutes on it. This is what I'm trying to do right now
hd2gTrT.png (615×375) (imgur.com)
Q4Iuv4z.png (615×207) (imgur.com)
iew6cXx.png (1036×182) (imgur.com)
where is expression in the compose is
div(sub(ticks(formatDateTime('tempo_fechamento', 'h:mm')),ticks(formatDateTime('tempo_abertura', 'h:mm'))),864000000000)
and the error I get is
Unable to process template language expressions in action 'Compose' inputs at line '1' and column '14946': 'In function 'formatDateTime', the value provided for date time string 'tempo_fechamento' was not valid. The datetime string must match ISO 8601 format.'.
could somebody give me a hint as what to do
