Member Avatar for 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

  • 3 Contributors
  • 2 Replies
  • 74 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by hadeeqa
Member Avatar for 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

Member Avatar for 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

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.