T
ty
I need to modify this statement:
(DateDiff("n",[QH_SUBMIT_TS],[QH_RELEASE_TS])/60)-Minus_Non_Work_Time([QH_SUBMIT_TS],[QH_RELEASE_TS])
The Minus_Non_Work_Time function substracts 16 hours everytime, but I need
to add back an additional hour for each hour QH_SUBMIT_TS is greater than
5pm. I know I need some form of IF statement, but I can't figure it out.
For example, if the QH_SUBMIT_TS is 6:30 PM, then I need to add 1 hour. If
the QH_SUBMIT_TS is 7:30, then I need to add 2 hours back. Please help.
(DateDiff("n",[QH_SUBMIT_TS],[QH_RELEASE_TS])/60)-Minus_Non_Work_Time([QH_SUBMIT_TS],[QH_RELEASE_TS])
The Minus_Non_Work_Time function substracts 16 hours everytime, but I need
to add back an additional hour for each hour QH_SUBMIT_TS is greater than
5pm. I know I need some form of IF statement, but I can't figure it out.
For example, if the QH_SUBMIT_TS is 6:30 PM, then I need to add 1 hour. If
the QH_SUBMIT_TS is 7:30, then I need to add 2 hours back. Please help.