Hi
I've managed to get a decminal value of seconds into HH:mm:ss:ms using
convert(char(12), dateadd(millisecond, (sum(totalduration)-cast(sum(totalduration) as int))*100, dateadd(second, cast(sum(totalduration) as int), 0)), 114)
but i have encounterd a issue where the value is too great and it goes over 1 day and it only returns the remander after the 1 day, how i can i work around this so it returns DD:HH:MM:SS:MS
Thanks
I've managed to get a decminal value of seconds into HH:mm:ss:ms using
convert(char(12), dateadd(millisecond, (sum(totalduration)-cast(sum(totalduration) as int))*100, dateadd(second, cast(sum(totalduration) as int), 0)), 114)
but i have encounterd a issue where the value is too great and it goes over 1 day and it only returns the remander after the 1 day, how i can i work around this so it returns DD:HH:MM:SS:MS
Thanks