Calculate internet usage

Hi there,

The basic problem is that you're trying to perform arithmetic calculations using string values. The following code seems to do what you require:

Please Login or Register  to view this content.

Note: in the highlighted line

Please Login or Register  to view this content.

your original code showed a * operator, but the operator you need is /.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg,

Thanks so much for your help. By the way, I don't understand why you devise txtDuration with 1440 ? ex: TimeValue(txtDuration) <= 15 / 1440

Is there another way to convert txtDuration to only number of minutes ?

Thanks again.

Regards,

Hi again,

Any time value in Excel lies in the range 0 to 1 - e.g.:

06:00 = 0.25
12:00 = 0.50
18:00 = 0.75

This means that the time value for one hour is 1 / 24 (the number of hours in a day) and the time value for one minute is 1 / 1440 (the total number of minutes in a day).

Your textbox txtDuration contains a string, e.g. "00:36", so you cannot perform any arithmetic calculations with it. You convert it to an arithmetic value by using the "TimeValue" function which gives a value of 0.0025. This value is greater than 30 / 1440 and less than 60 / 1440, so it corresponds to the duration range 30 - 60 minutes.

I think the following code might be a bit neater than the previous version (although it does exactly the same thing!):

Please Login or Register  to view this content.

I hope this is of some assistance to you - please let me know if you need any other information.

Regards,

Greg M

Hey !!

Need help !!

I downloaded this calculator...but got a blank excel sheet