Hi
I want to subtract punch out from punch in. (Punch out - Punch In)
But I only want the time difference.
How can we do thiis.
Thank you advance.
Solved! Go to Solution.
@sgaryali , Here is the workflow to achieve your solution. Let me know if you need any help.
Thanks!!
Hey @sgaryali,
Here is one way:
I used the text to column tool to split out the date and then use the date time functions to calculate the diff in minutes.
If your interested in learning more about the datetime functions there is a great cheat sheet Blog here: https://community.alteryx.com/t5/Engine-Works/DateTime-Functions-Cheat-Sheet/ba-p/844353
Any questions or issues please ask
Ira Watt
Technical Consultant
Watt@Bulien.com
Thank you for your response.
I also though about this formula but One thing I missed to add is that
I want output in HH:MM format.
By this I either getting hours, minutes, seconds.
How can we do that?
For a HH:MM format you could use something like the following @sgaryali:
Padleft(ToString(FLOOR([Minute difference]/60))+':'+ToString(Mod([Minute difference], 60)),5,'0')
@sgaryali , Always there to help you. You can use formula to get your desired output. Attaching the updated workflow. Please do accept my solution if it helped.
Thanks!!