Multiply values in ACCESS 97 1

[sanjna000]

Hi guys,

I need to calculate total charges by multiply charge rate with the visit length for each client in my company. At the moment client visit is in text data type so that i really don't know how to convert text into numeric inorder to perform calculaton.

At present staff enters data as follows:
for 1/2 hr visit length = 00:30
for 3/4 hr visit length = 00:45
for 1 hr visit length = 01:00

Is any one know how to calculate total charges using these text fields?

Thank you so much for u r help in advance.
Sanju

 

[Malchik]

the best way to do it, is to convert the time in minutes and multiply it by the rate. Example:

cRate = 17.00
sT = "03:54"

(val(left(<time>,2)) + (val(right(<time>,2))/60)) * <rate>

exval(sT,2)) + (val((right(sT,2))/60)) * cRate
3 + .9 * 17 = 66.30

Mal'chik

 

[sanjna000]

Hi Mal'chik,
Thank you sooooooooooo much for all u r help. It works fine as I expected. You are a star!!!

Sanjna