Calculate time difference

[Kalivati]

hi,
I have a form from a table with 4 fields namely Date Issued,Time Issued,Date Cleared & Time cleared. In a textbox I want the difference in time to be entered automatically after I fill all the 4 fields in the form.
I know a bit of VB 6.

could you please help me.

Thanking you in advance
Kalivati

 

[namliam]

you can add the date and time fields together then substract the two to find the difference.

Something like so:
(Date Cleared + Time cleared) - (Date Issued +Time Issued)

Good luck

 

[Kalivati]

Can you or anyone show the actual coding for me please.
This is what i started with.

Private Sub Command59_Click()
Dim datStart As Date
Dim datStop As Date
Dim txtDate As TextBox
Dim txtDateCleared As TextBox

txtDateIssued.Text = datStart
txtDateCleared.Text = datStop

OutageTime.Text = "Report took " & DateDiff(DateInterval.Second, datStart, datStop) & " seconds"

End Sub

 

[namliam]

Can you or anyone show the actual coding for me please.

which is what I allready did, more or less...

This is what i started with.

Private Sub Command59_Click()
Dim datStart As Date
Dim datStop As Date
Dim txtDate As TextBox
Dim txtDateCleared As TextBox

txtDateIssued.Text = datStart
txtDateCleared.Text = datStop

OutageTime.Text = "Report took " & DateDiff(DateInterval.Second, datStart, datStop) & " seconds"

End Sub

Something like so??
DateDiff(DateInterval.Second, (Date Cleared + Time cleared), (Date Issued +Time Issued))

 

[kevlar]

I tried a variation of this, (at least I think its similar) only time involved no dates

=HoursandMinutes([time finished]-[time started])

it works fine in the form and calculates the elapsed time, no problems. It doesnt save the calculated values to the table however, saves them in the form but doesnt transfer them to the table. Is there a way to change this?