reporting services - Converting seconds to HH:MM:SS in SSRS using function -
i had function below working convert seconds hh:mm:ss in ssrs. needs work seconds in excess of 86400 i.e. total time greater 24 hours. function below returning strange values 00:00:.2 or 00:00:75 public function convertsecondstohourminsec(byval inttotalseconds) string dim hours string =int(inttotalseconds/3600) if len(hours) < 2 hours = right(("0" & hours), 2) end if dim mins string = right("0" & int((inttotalseconds mod 3600)/60), 2) dim secs string = right("0" & ((inttotalseconds mod 3600) mod 60), 2) convertsecondstohourminsec = hours & ":" & mins & ":" & secs end function passing function value of 227.16666 gives 00:03:67, example. any idea how can fix function give hh:mm:ss? realized wasn't converting seconds int on bottom. works now.