I need to be able to get the total hours and minutes if it is over 24 hours from a decimal column in SQL Server.

This is the code I am using:

```
CAST(CAST(DATEADD(SECOND, 1654.86 * 60, 0) AS Time(0)) AS VARCHAR(5))

```

Since it's over 24 hours the output is "03:34" I would like for it to be "27:34" or if possible to tell me it will take 3 working days and "03:34" (not sure how that would work).

Thank you in advance! Paul