Report Performance

[checkai]

I'm trying to create a report that shows the performance of each, but getting some results that I'm not sure are correct. Please review my statement to see if I'm manipulating the milliseconds appropriately. Thanks!

LEFT('0' + convert(char, CONVERT(int,(x.TimeRendering/3600000) % 24)),2) + ':' + --Hours
		LEFT('0' + convert(char, CONVERT(int,(x.TimeRendering/60000) % 60)),2) + ':' + --Minutes
		LEFT('0' + convert(char, CONVERT(int,(x.TimeRendering/1000) % 60)),2) + ':' + --Seconds
		LEFT('0' + convert(char, CONVERT(Int,(x.TimeRendering % 1000))),2) as TimeRendering,--Milliseconds 
		x.TimeRendering+x.TimeDataRetrieval+x.TimeProcessing as TotalTimeActual,
		LEFT('0' + convert(char, CONVERT(int,((x.TimeRendering+x.TimeDataRetrieval+x.TimeProcessing)/3600000) % 24)),2) + ':' + --Hours
		LEFT('0' + convert(char, CONVERT(int,((x.TimeRendering+x.TimeDataRetrieval+x.TimeProcessing)/60000) % 60)),2) + ':' + --Minutes
		LEFT('0' + convert(char, CONVERT(int,((x.TimeRendering+x.TimeDataRetrieval+x.TimeProcessing)/1000) % 60)),2) + ':' + --Seconds
		LEFT('0' + convert(char, CONVERT(Int,((x.TimeRendering+x.TimeDataRetrieval+x.TimeProcessing) % 1000))),2) as TotalTime,--Milliseconds