camelk
03-20-2002, 09:18 PM
I need help calculating the total time worked over a specified period of time. I stored StartTime and EndTime in 2 fields as short. Subtracted EndTime from StartTime to calulate the amount of time work in one day (this worked fine). But how do I add up these totals to get the TotalTime Worked. I tried to "sum" the daily totals but got a data type error. Please Help. Thanks