hello. I have a problem here which I don't know that can be solved.

I need to transform some decimals to time and in another column know the
time in days.

I have this e columns:
34 0,875 34,875

if I divide by 24 and format as time I have this:
10:00 0:52 10:52

The problem is when the sum is bigger then 24 hours, so I have this:
0,13 0,91 1,04

And is show me this:
3:00 21:52 0:52

and I need this:
3:00 21:52 24:52

But if I format all column with this format: [h]:mm:ss;@

In the first example I have get this:
10:00 0:52 34:52:30

How can I fix this?


Thanks,
Marco