Want the SQL Server hh:mm time in [h]:mm like MS Excel

1

Hi team,
I want the following string output
convert(varchar(2),(FORMAT(SUM(datediff(minute, Trandate , Workinghrs))%3600/60,'0#'))) +':'convert(varchar(2),FORMAT(SUM(datediff(minute , Trandate , Workinghrs))%60,'0#')) AS WorkingHrs

in [h]:mm format

Thanks

2

Calculation of hour in Excel using [h]:mm formula - Super User