Format to display hh:mm:ss

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FotoArt - 03 Mar 2006 17:44 GMT

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

Reply to this Message

Jezebel - 04 Mar 2006 00:00 GMT

Dim pMinutes as long

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

> hello everyone
>
[quoted text clipped - 12 lines]
> thanx
> ahmed

Reply to this Message

FotoArt - 04 Mar 2006 08:23 GMT

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

its working great

ahmed

> Dim pMinutes as long
>
[quoted text clipped - 17 lines]
> > thanx
> > ahmed

Reply to this Message

Jezebel - 04 Mar 2006 08:43 GMT

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

> thanx Jez
> I had to change 1440 to 8600 to make my calculation work.
[quoted text clipped - 24 lines]
>> > thanx
>> > ahmed

Reply to this Message