Format to display hh:mm:ss

[FotoArt]

hello everyone

I have the following line of code

..Caption = Format((lngWords \ 90), "##,##0") & " minutes of Text - Microsoft
Word"

I want to convert the lngWords to hh:mm:ss
my formula would be
(((lngWords / 1.5) / 60) / 60) / 24

Any kind of help would be appreciated

thanx
ahmed

 

[Jezebel]

Dim pMinutes as long

pMinutes = lngWords / 1.5
..Caption = format$(pMinutes/1440, "hh:mm:ss")

 

[FotoArt]

thanx Jez
I had to change 1440 to 8600 to make my calculation work.

its working great

ahmed

 

[Jezebel]

There are 1440 minutes in 24 hours. What time scale are you working to?