I need to calculate the duration of the assignment. And for this purpose I created a field ‘date interval’.
In my case, the user clicks the task start, after a few hours (after work), he clicks finish work and then I want to save this interval in the date interval field. But after writing in my date interval, I saw the value: -1656440437237 for the 1 minute task duration.
Have an idea what I can do?
Hi there, @jakub.lankiewicz… if I understand your post correctly, it sounds like you could save a start date/time when the user starts the task and then save (in a separate field, of course) an end date/time when the user finishes the task. With both of those dates/times saved for a task. you could simply subtract the start date/time from the end date/time and format the results as, say, hours or minutes, and you’d be good to go.
Anyway, just food for thought there… if you want more specific help on this one, you will need to share screenshots of your setup.