Clarificaiton on Date/Time

[hemashiki]

i have two textboxes one contains the intime(which in AM) and another contains the outtime(which is in PM).hence the worked hours must be the difference between the two (outtime and intime)

for eg:

intime=9:00AM
outtime=5.00PM

then the worked hours must be( 8 )
but the result i got is -4

can any one suggest plz :p

[sashi]

Hi there,

use the below attached code segment for calculating time difference in vb, good luck and take care my fren.. :)

Dim time1 As Date, time2 As Date, interval As Long  
  
time1 = Format(Now, "HH:mm:ss")  
  
time2 = Format(Now, "HH:mm:ss")  
  
interval = DateDiff("s", time1, time2)  
  
MsgBox "The MessageBox was displayed from " & time1 & " until " & time2 & ".  
  
an elapsed time of " & interval & " seconds."

[hemashiki]

hi
thanks for ur code.......
take care :cool: friend

[sashi]

Hi Hemashiki,

Anytime my fren.. hope to see more questions from you in the future :)
u take care too..

[hemashiki]

Hi sashi....
i have one query....in data grid
how to clear the data grid while loading the form.

i have used datagrid1.clear ,but its not working
can u suggest me............. ............... .......
take care friend :p