FUNCTIONS

[Guest]

I have a field in my form called total time; it calculates the time out minus
the time in and gives me the difference in a time format. I know want to
change that to be a number format so that I can times the number by a rate.
Is this possible?

 

[Jeff Boyce]

Renee

Take a look at the CInt() (or CCurr(), or ...) function in Access HELP.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Vinson]

I have a field in my form called total time; it calculates the time out minus
the time in and gives me the difference in a time format. I know want to
change that to be a number format so that I can times the number by a rate.
Is this possible?

How does it do the calculation?

I'd suggest using DateDiff("n", [Time In], [Time Out])

to get integer minutes (divide by 60 to get fractional hours of
course).

John W. Vinson[MVP]

 

[Guest]

My first calculation to figure out the total time is: =HoursAndMinutes([TIME
OUT]-[TIME IN]).
Then in a seperate field I would like it it take this number and convert it
to a number instead of time format so I may calculate it with a rate.

I have a field in my form called total time; it calculates the time out minus
the time in and gives me the difference in a time format. I know want to
change that to be a number format so that I can times the number by a rate.
Is this possible?

How does it do the calculation?

I'd suggest using DateDiff("n", [Time In], [Time Out])

to get integer minutes (divide by 60 to get fractional hours of
course).

John W. Vinson[MVP]

 

[John Vinson]

My first calculation to figure out the total time is: =HoursAndMinutes([TIME
OUT]-[TIME IN]).

That returns a Text string.

Then in a seperate field I would like it it take this number and convert it
to a number instead of time format so I may calculate it with a rate.

Why call a function to convert two times to a text string, and then
another function to convert it back to a number? You only need ONE
function call - DateDiff() - to get a number which can be used in your
calculation.

If you need both the HoursAndMinutes for display, and the DateDiff()
for the rate calculation, just use two separate calculations.

John W. Vinson[MVP]

 

[Guest]

So how do I use the DateDiff() function then? I looked on the help and can't
seem to figure it out.

My first calculation to figure out the total time is: =HoursAndMinutes([TIME
OUT]-[TIME IN]).

That returns a Text string.

Then in a seperate field I would like it it take this number and convert it
to a number instead of time format so I may calculate it with a rate.

Why call a function to convert two times to a text string, and then
another function to convert it back to a number? You only need ONE
function call - DateDiff() - to get a number which can be used in your
calculation.

If you need both the HoursAndMinutes for display, and the DateDiff()
for the rate calculation, just use two separate calculations.

John W. Vinson[MVP]

 

[Guest]

I have figured it out now. Thank you very much for you help and time

Renee

My first calculation to figure out the total time is: =HoursAndMinutes([TIME
OUT]-[TIME IN]).

That returns a Text string.

Then in a seperate field I would like it it take this number and convert it
to a number instead of time format so I may calculate it with a rate.

Why call a function to convert two times to a text string, and then
another function to convert it back to a number? You only need ONE
function call - DateDiff() - to get a number which can be used in your
calculation.

If you need both the HoursAndMinutes for display, and the DateDiff()
for the rate calculation, just use two separate calculations.

John W. Vinson[MVP]

 

[John Vinson]

So how do I use the DateDiff() function then? I looked on the help and can't
seem to figure it out.

The first argument of DateDiff is a text string indicating the unit of
measure: "s" means Seconds, "n" miNutes, "h" Hours, "d" Days, "m"
Months. The second argument is a date/time value for the beginning of
the interval, the third is a date/time value for the end. So

DateDiff("n", [Start Time], [End Time])

would return 360 (minutes) if the end time is six hours after the
start time.

John W. Vinson[MVP]