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?
Hi
Can anyone help?
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.