I can't seem to retrieve the right formula to get 7:00PM as a result on the Date/Time value.
I have tried a lot of decimal values but nothing seems to reach 7:00pm. Please help.
(DATETIMEVALUE( TEXT(YEAR(TODAY())) + "-" + TEXT(MONTH(TODAY())) + "-" + TEXT(DAY(TODAY())) + " 23:42:00")) - 0.0003
I need it to appear as 7:00 PM for the Nonworking Resource
