I am trying to subtract 1 hour from the time taken to do a task. Time taken is in HH:MM:SS format. So if I have 01:42:30 as time taken to do a task then I would want to subtract an hour from that to make the value 00:42:30.
I would then want to put this into categories. So there would be a category for items < 1 hour, > 1 hour and > 12 hours.
Thank you
Below how you can substract 1 hour.
Howerver I didn't get the second part of your need. Could you share a sample data with what you expect to have?
Attached the workflow,
Regards,