Sample Header Ad - 728x90

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