Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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