I use MS SQL Management Studio to pull queries from our ticketing system. Attached is a sample of the data so you can see the formats for each column.
I need to do add a column showing the 'SLA duration' which would subtract the suspend hours from the total duration. Total duration should be the service restore date/time minus the create date/time. I can subtract the time stamps but adding in the suspend hours to the equation messes it up.
The SLA duration should display in a number with decimal
[(service restored date/time) - (create date/time)] - Suspend Hours
Current format when exported with headers
service restored date/time - custom
create date/time - custom
suspend hours - general
Note: I have also tried to import this into PowerPivot but am not able to convert the suspend hours to a number. Also, I need to be able to do this with a formula, rather than vb.