Combine INT, TIME fields and compute Elapsed Percentage
0
votes
0
answers
19
views
Need calculation and conversion help...
Columns:
[Days] INT
[hh:mm:ss] Time
[AllowedRuntimeMinutes] INT
Need to combine [Days]+[hh:mm:ss] as the duration the query has been running, and then calculate the elapsed percentage over the allowed run time.
So possibly some form of ([Days]+[hh:mm:ss] as Duration)-AllowedRuntimeMinutes/AllowedRunTimeMinutes*100 ?
Asked by CrushingIT
(33 rep)
Jun 8, 2023, 02:55 PM