Time Diff

[arun5]

Hi All,

This is Arun,

• I have two times enter and exit. i want see the time diff. i used datetimediff('end time','start time','min') but i was getting output column values as null. please any suggestions.
• Here, I have attached input and output screenshots.

[Emil_Kos]

Hi @arun5,

This is the exam question? 

[mceleavey]

[AngelosPachis]

@arun5 I believe this is a weekly challenge, or if it's not it is very similar to challenge #106

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-106-How-Long-were-the-Lights-On/td-p/142...

You can download any of the responses submitted there and reverse-engineer why your formula doesn't work.

(I guess is the part of the day you are using, maybe try "minutes" instead of "min")