SOLVED
Convert Excel decimal time to time in Alteryx
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
AlexL
7 - Meteor
‎12-28-2018
12:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
Inquiring if there is a tool or way to convert a decimal field in an excel report to time in Alteryx.
The select tool does not recognizing the decimal field as time when I change the format.
I.e.
0.486643518518518 = 11:40:46 AM (hh:mm:ss)
0.5 = 12:00:00 PM (hh:mm:ss)
Please see additional examples in attached document.
Solved! Go to Solution.
2 REPLIES 2
ACE Emeritus
‎12-28-2018
01:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎12-28-2018
02:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks! Works perfect!
