Subtract 1 hour from time in HH:MM:SS format
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
cayladuplooy
7 - Meteor
‎12-21-2021
06:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎12-21-2021
11:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
15 - Aurora
‎12-22-2021
12:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
