How to calculate time and charges

[remo1120]

How to calculate time and charges in atomaticaly
Example: Per hours 10.00,
Name : Mano
Starting Time : 14:00
Finishing time : 16:45
Total Hrs : 2:45
Charges : 28

please help me if have any formula
Thank you
Remo

[QVeen72]

Hi,

Try This :

Dim T As Long
Dim TAmt As Currency
T = DateDiff("n", CDate("14:00:00"), CDate("16:45:00"))
TAmt = (10 * T) / 60
MsgBox TAmt

Refine the code according to your requirement...

Regards
Veena

[hadeeqa]

how to calculate total and save in database sccess.

four user input in text box add total and save all fields in access data base.

for example...

student all subject result.
1- chemistry number = 50
2- math = 80
3- Physics = 90
4- Bio =85

Grand toal =?
total Percentage = ?

all value save in database code.
pleas help me if any code...

thanks.

Hadeeqa