TimeSerial

  • Thread starter Thread starter Ray Hogan
  • Start date Start date
R

Ray Hogan

Hi,
I have a report in which I need to print a series of values using the
following formula TimeSerial([txtTeeTime],11,0)+[txtTeeTime]. However, when
I enter values greater than 12:00 in [txtTeeTime], the result increases by 1
hour.
Please advise and what are my options.
Thanking you in anticipation.
Rayh.
 
I just have a number of Textbox with differnt minute values.
Regards.
Rayh
Douglas J. Steele said:
Let's see more of the code you're trying to use.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Ray Hogan said:
Hi,
I have a report in which I need to print a series of values using the
following formula TimeSerial([txtTeeTime],11,0)+[txtTeeTime]. However, when
I enter values greater than 12:00 in [txtTeeTime], the result increases
Click to expand...
by
1
hour.
Please advise and what are my options.
Thanking you in anticipation.
Rayh.
Click to expand...
Click to expand...
 
So what exactly is in them? In your original question, you mention "values
greater than 12:00". For your code to work, you must have only a single
number, not two separated by a colon. And now you're mentioning that the
textboxes contain minutes, yet you've got txtTeeTime in the Hours position
of the TimeSerial function. Why are you adding txtTeeTime to the results of
the TimeSerial function anyhow?

Let's go back a couple of steps. What exactly are you trying to achieve?

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Ray Hogan said:
I just have a number of Textbox with differnt minute values.
Regards.
Rayh
Douglas J. Steele said:
Let's see more of the code you're trying to use.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Ray Hogan said:
Hi,
I have a report in which I need to print a series of values using the
following formula TimeSerial([txtTeeTime],11,0)+[txtTeeTime]. However, when
I enter values greater than 12:00 in [txtTeeTime], the result
Click to expand...
Click to expand...
increases
by
Click to expand...
Click to expand...
 
Hi,
In txtTeeTime I am entering a time value and I want to the other textboxs to
produce values say 11 minutes later or whatever value I enter in Timeserial.
regards.
Rayh
Douglas J. Steele said:
So what exactly is in them? In your original question, you mention "values
greater than 12:00". For your code to work, you must have only a single
number, not two separated by a colon. And now you're mentioning that the
textboxes contain minutes, yet you've got txtTeeTime in the Hours position
of the TimeSerial function. Why are you adding txtTeeTime to the results of
the TimeSerial function anyhow?

Let's go back a couple of steps. What exactly are you trying to achieve?

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Ray Hogan said:
I just have a number of Textbox with differnt minute values.
Regards.
Rayh
Douglas J. Steele said:
Let's see more of the code you're trying to use.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Hi,
I have a report in which I need to print a series of values using the
following formula TimeSerial([txtTeeTime],11,0)+[txtTeeTime]. However,
when
I enter values greater than 12:00 in [txtTeeTime], the result
Click to expand...
increases
by
1
hour.
Please advise and what are my options.
Thanking you in anticipation.
Rayh.
Click to expand...
Click to expand...
Click to expand...
 
To add eleven minutes to a time, use DateAdd("n", 11, [MyTime])

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Ray Hogan said:
Hi,
In txtTeeTime I am entering a time value and I want to the other textboxs to
produce values say 11 minutes later or whatever value I enter in Timeserial.
regards.
Rayh
Douglas J. Steele said:
So what exactly is in them? In your original question, you mention "values
greater than 12:00". For your code to work, you must have only a single
number, not two separated by a colon. And now you're mentioning that the
textboxes contain minutes, yet you've got txtTeeTime in the Hours position
of the TimeSerial function. Why are you adding txtTeeTime to the results of
the TimeSerial function anyhow?

Let's go back a couple of steps. What exactly are you trying to achieve?

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Ray Hogan said:
I just have a number of Textbox with differnt minute values.
Regards.
Rayh
Let's see more of the code you're trying to use.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Hi,
I have a report in which I need to print a series of values using the
following formula TimeSerial([txtTeeTime],11,0)+[txtTeeTime]. However,
when
I enter values greater than 12:00 in [txtTeeTime], the result increases
by
1
hour.
Please advise and what are my options.
Thanking you in anticipation.
Rayh.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top