[dpmangold]

Hi, All..new to the forum.. and a fairly beginner vb programmer.

I have been trying to figure out without success how to convert a large number of seconds to hours... i have it working when the conversion does not exceed 24 hours.. but when it exceeds 24 hours the conversion is incorrect.. Below is the code I am using with a test total seconds amount of 95000 seconds (I want it converted to 26:23 as in 26 hours.. 23 minutes)

MyTotal = 95000

MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Rows - 1, 4) = Format(DateAdd("s", MyTotal, #12:00:00 AM#), "HH:nn")

this is the only code i could find to make it work.. but it only works when the seconds total less than 24 hours..

[Squashman]

Wow, the power of Google. Did a google search for [b]convert seconds to hours and found this.

http://www.freevbcode.com/ShowCode.asp?ID=85

[dpmangold]

Thanks... I knew I should have bought their stock... plus they beat earnings today.... have a great weekend.

[dsovic]

Originally Posted by dpmangold

Thanks... I knew I should have bought their stock... plus they beat earnings today.... have a great weekend.

Do the math:
1 hour = 60 minutes
1 minute = 60 seconds
----------------------
1 hour = 3600 seconds

So, to convert seconds to hours make an integer division with 3600.

[Shadow2531]

Also if myTotal is constant as it appears to be, you would just set what it is in hours, in initialization. Or, if myTotal was used elsewhere for second representation, you could have another variable (myTotalInHours) if you wanted.