rounding numbers on list box

  • Thread starter Thread starter chas0503
  • Start date Start date
C

chas0503

I am developing a program to record time spent on a
task. In order to assist the person entering the data, I
have created a listbox with 2 columns. The first column
tells the operator when the task is started (1:15 PM) and
the second column converts the text to an number that I
can manipulate in my time calculations. I would convert
the text of 1:15 PM to 13.25
I have created a list box to do this operation but when I
click on the number that I want to enter in the proper
field (13.25), the number that is enter is rounded to 13.
What formats should I use in both the table and the list
box?
 
Not sure why you would need to convert if you set it up properly and use
the datediff function.
Example:
datediff("n",#6/10/04 13:25:00 pm#,#6/10/04 15:55:00 pm#)
returns 150 minutes.

Damon
 
Back
Top