Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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