TIME DIFF WITH CONDITION

[sgaryali]

Hi Want to calculate the number if hours between Punch In Time New and Punch Out Time New.

But it should be between 22:00:00 to 6:00:00.

For ex - if a person punch in at 20:00:00 and punch out at 7:00:00 the alteryx should calculate time between 22:00:00 to 6:00:00.

or let's say if person punch in at 18:00:00 and punch out at 24:00:00 the alteryx should calculate time between 22:00:00 to 6:00:00.

How can we calculate it?

[sgaryali]

Hi

Can anyone help?

[apathetichell]

You need dates. Time doesn't work on a 24 hour cycle in Alteryx - dates do. Ask this question on the Designer page - not the Server page, you'll get more results.