convert decimal value to DD hh:mm:ss

[Damncold]

Hi,

i try to convert several decimal values into Days Hours:Minutes:Seconds
my problem is the following.
If i user the format DD hh:mm:ss
values over 32 will start counting the days from 0 (like a new month).
and if i format it like M D h:m:s values < 32 days gets displayed with a 1 (for the month) before the days.

Please Login or Register  to view this content.

is there a way to get only the count of days displayed without the summarization to months?

Thanks in advance!

regards

Marco

[XOR LX]

Hi,

Not sure I understand. Your desired result for:

33.2149789 is 34 5:9:34

and for:

40.5465546 is 41 13:7:2

Can you explain why?

Regards

[Paul]

My guess is typo, XOR.

[XOR LX]

My guess is typo, XOR.

Looks like a strong bet!

I don't know how to do this and leave the result as a numeric. If you can live with a text result:

=INT($A1)&" "&TEXT(MOD($A1,1),"hh:mm:ss")

though obviously this will not allow you to perform any mathematical operations on these results.

Regards

[Damncold]

yes a typo sorry.
i dont want to calculate with the result, only filter.
but i want to have the result in the same cell
like with changing the cell format.
Any ideas?