Cell format in excel

[Guy Cohen]

Hi all.
I wrote a VB program that gather duration of some process and stores it in
an Excel report.
The duration should be presented as hours:minutes:seconds
Hours might be >24 (e.g. 30:12:03)
The number is not presented right on the sheet instead of the sample above
the cell contains a fraction (e.g. 0.12345)

I tried .numberformat ="@" but it did not help

What other number formats exists ?

Please advise
Guy

 

[Perry]

Pls turn to the appropriate newsgroup for this

FYI:
microsoft.public.excel.programming

Krgrds,
Perry