How can i solve this Time calculation problem

J.wills · 03-12-2009, 02:15 AM

Hi,

Is there a way I can enter a one to three digit number, have it appear as a three digit number, but have it stored in short time

(nn:ss). For instance, in a form or table, I want to enter the number 135 and have it displayed as 135. However, I want the number

stored as 02:15, meaning that the 135 is one hundred and thirty five seconds. This then gets stored as 2 minutes 15 seconds. I plan

to use the stored 02:15 in a later time calculation.

Any help is appreciated.

**ExlGuru** · 03-19-2009, 12:14 AM

First of all you have to define a function to hold the min:sec variables

This should be helpful for you......

Please Login or Register  to view this content.

J.wills · 03-19-2009, 12:17 AM

Its working thanks for the reply ExlGuru......

**JBeaucaire** · 03-19-2009, 12:25 AM

Removed as unnecesary.

**mudraker** · 03-19-2009, 07:02 AM

J.wills

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save