Hi Xavier,

Why not simply select the sum cell and custom format it as suggested?

Format | Cells | Custom | dd hh:mm

Obviously, you will need to adjust this to accord with your German version
of Excel.

Incidentally, using your Text function worked for me with the indicated
data.

---
Regards,
Norman



"Xavier" wrote in message
...
i tryed with

=TEXT(SUM(F39);"tt:hh:mm")
or
=TEXT(SUM(F39);"tt hh:mm")
because it is a german version instead of dd .....

but it displays a wrong value

for 28 hours it displays 02 04:00

any ideas?
thanks





"Xavier" wrote:

formatting with time 37:30:55 will display the corect values in hours
but
not the values in a format like:
day hours:minutes...

regards