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