Hello,

The code below will give you the number of minutes between two times. Replace EndTime and StartTime with the names of the time elements on your form and TimeWorked with the name of the element that you want to display the result in.

TimeWorked = EndTime - StartTime 

If you want to get hours and minutes then the following code should give you start in the right direction.

Var vDiff as Int
Var vHours as Int
Var vMins as Int

vDiff = EndTime - StartTime
vHours = @Int(vDiff / 60)
vMins = vDiff - (vHours * 60)

HoursWorked = vHours
MinutesWorked = vMins 

Replace EndTime and StartTime with the names of the time elements on your form. Also replace HoursWorked and MinutesWorked with the name of the elements that you want to display the result in.

Let me know if you have any Questions.

Welcome to the Forum,
Ray

Hello,

In Designer click on the EndTime element
Switch to the Other Tab of the Property Viewer
What does it say next to Bound To Type?

Click on the StartTime element
On the Other Tab of the Property Viewer, what does it say next to Bound To Type?

If Bound To Type says "Text" you will need to change that to "Time". Instructions for changing Field Type can be found on pages 138-139 of the Sesame 1.1 User Guide.

-Ray

drastixnz wrote on Jan 2^nd, 2007 at 9:42pm:

Don't feel bad, I've made that same mistake more times than I would like to admit.

Quote:

You are most welcome.
-Ray