Subtract 1 hour from time in HH:MM:SS format

Question

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

messi007 · Answer

@cayladuplooy,

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,

-1Hour_20211222.yxmd

binu_acs · Answer

@cayladuplooy

Spoiler

hour.yxmd