How to add two time fields (24 hour format) in Alteryx ? Please help
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everyone, I am looking for an easier solution on how I can add two time fields in Alteryx, For Example -
Time1 Time2
09:00:00 00:10:00
10:15:00 00:45:00
12:40:00 00:30:00
So I want to add these two column and get my final column as
Time3
09:10:00
11:00:00
13:10:00
How can I get this result ? Help please
Solved! Go to Solution.
- Labels:
- Date Time
- Time Series
- Tips and Tricks
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AbhirupMukherjee09 the below post might be helpful for your use case
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Adding-Times-Together/td-p/8658
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @AbhirupMukherjee09, here's one way you could go about achieving this where you parse out the hours/minutes/seconds of Time2 and individually add them to Time1. I've added an extra row to show all 3 working at once and correctly ticking over midnight:
The only 'standout' thing to mention is creating a *dummy* DateTime to be able to use the DateTimeAdd(), hence the '1900-01-01 '+
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks alot @DataNath. This is exactly what I was looking for.
