Difference Between Time

[sgaryali]

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.

[grazitti_sapna]

@sgaryali , Here is the workflow to achieve your solution. Let me know if you need any help.

Thanks!!

[IraWatt]

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 

[sgaryali]

Hi @IraWatt  @grazitti_sapna 

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?

[DataNath]

Can tackle this using a single Formula tool with DateTimeParse() and the DateTimeDiff() functions:

DateTimeDiff(DateTimeParse([Punch-Out],'%d-%b-%Y %H:%M'),DateTimeParse([Punch-In],'%d-%b-%Y %H:%M'),'minute')

[DataNath · Accepted solution]

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')

[grazitti_sapna · Accepted solution]

@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!!