Hi all,
I've been trying to add the following values in a form, but I don't
know how to do it:
Start Stop WorkedHours SET UET Other Time TotalHours
08:00PM 04:00PM 8:00 05:00 08:00
The DataType of these fields are:
Start: Date/time
Stop: Date/time
WorkedHours: TEXT
SET,UET,OtherTime,TotalHours: TEXT
The problem is that when the employee enter, for instance, in the SET
field: 05:00. I want this field to add up to Totalhours,the same thing
with UET,Other Time..
I tried to change the datatype of these fields to Date/Time, but
when I choose the input mask 00:00, I end up having 00:00AM, and I
don't really want that. The start and stop, works fine...
I've been working on this for a very long time, and I haven't be able
to find out the function..here is the Function that I am currently
using for Start and Stop fields.
Dim Intintervalminutes As Integer
Intintervalminutes = DateDiff("n", Me.Start, Me.Stop)
Me.totalHours = Intintervalminutes \ 60 & Format(Intintervalminutes
Mod 60, "\:00")
Me.TotalHours = Me.WorkedHours
Me.WorkedHours = Me.TotalHours
Thanks in advanced..