DateDifference and Time 12-30-18 1:53 AM 12-30-18 2:08 AM 12-30-18 3:12 AM 12-30-18 3:27 AM 12-30-18 4:00 AM 12-30-18 4:15 AM 12-30-18 2:30 AM 12-30-18 2:45 AM 12-30-18 3:20 AM 12-30-18 3:35 AM 12-30-18 2:30 AM 12-30-18 2:45 AM 12-30-18 4:12 AM 12-30-18 4:27 AM 12-30-18 4:00 AM 12-30-18 4:15 AM 12-30-18 5:16 AM 12-30-18 5:31 AM 12-30-18 4:59 AM 12-30-18 5:14 AM
We are happy to help.
but can you at least give clear description of your challenge?
In this case,
1. what would be the definition of of "Time difference"?
2, Data in structure, rathan then just a paragraph
3. What is the expected output?
@rohit782192 one way of doing this, is first you need to convert the given date in the Alteryx DateTime format, then you need to use the DateDiff function to calculate the difference.
Hi, @rohit782192
Maybe this is your want ?
If you follow datatime format-syntax as @binuacs , the formula tool of 2nd step is not need.
%m-%d-%y %I:%M %p
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |