JenHamilton_Tye
5 years agoQrew Trainee
Subtract business hours from timestamp
I have a time stamp field called "Deadline" and I want to subtract business hours from it (weekday hours.) How?
ToWeekdayP([Deadline]-Hours(#))
This doesn't work, it just knocks the result to a Friday if it falls on Sat/Sun.
Subtracting 36 business hours from an 8am Monday deadline should return Thursday at 8pm, not Friday at 8pm.
------------------------------
Thanks,
Jen Hamilton
------------------------------
ToWeekdayP([Deadline]-Hours(#))
This doesn't work, it just knocks the result to a Friday if it falls on Sat/Sun.
Subtracting 36 business hours from an 8am Monday deadline should return Thursday at 8pm, not Friday at 8pm.
------------------------------
Thanks,
Jen Hamilton
------------------------------