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

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.