Solved: need help to display workhours in days:hours:minutes

[Ger]

Hi,

i need help to view figures in workdays, houres and minutes.
p/a i have 1,5 workday (of 8 hours).
I want to display it like this
days:hours:minutes
1:4:0

(see attachment)

Ger

[Bob Phillips]

Maybe this

=INT(B21)&":"&MOD(B21,1)*8&":0"

[Ger]

i get an error on "&mod(B21,1)
I'm working with the dutch version of excell.

I've changes "mod" into "rest" and the "," into ";". Now i get the days and hours but i still miss the minutes for other values p/a 1,333 day = 1day, 2 hours and 39:50 minutes

[Bob Phillips]

Update

=TEXT(INT(B2),"00:")&TEXT(INT(MOD(B2,1)*8),"00:")&TEXT(INT(MOD(MOD(B2,1)*8,1)*60),"00")

[Ger]

This is the dutch version. This works fine.

=TEKST(INTEGER(B6);"00:")&TEKST(INTEGER(REST(B6;1)*8);"00:")&TEKST(INTEGER(REST(REST(B6;1)*8;1)*60);"00")

I had to change the "," into ";"

Thx a lot.

Ger