I have a date/time column from when an email arrives, for a service to be completed in hours, according to a SLA table, depending on urgency.
Each situaion results in a different number of hours, like 1, 12, 24, 48, etc.
I already created a column that returns the number of hours
How can I add that number of hours to the DateTime column? If I divide by 24 (which gives me a decimal result of “days”) and use the dateadd function, it always give me the correct number of days ahead, BUT 00:00 hours!