Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

cayladuplooy
7 - Meteor

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

2 REPLIES 2
binuacs
21 - Polaris

@cayladuplooy 

 

Spoiler
binuacs_0-1640157546311.png

 

messi007
15 - Aurora
15 - Aurora

@cayladuplooy,

 

Below how you can substract 1 hour.

messi007_0-1640162046577.png

 

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,

Labels
Top Solution Authors