More examples of source data and desired results would be helpful.

Meanwhile,
With
A1: (a number intended to convey days, hours, and minutes.....eg 100842)

This formula presents the components of that number, separated by colons (
B1: =TEXT(A1,"0\:00\:00")
In the above example, 100842 displays as 10:08:42

Is that something you can work with?