I have a form that shows the start time and finish time (timesheet) as well as other information. The question is, how do you make a textbox calculate the total number of hours worked? I have manually entered the number of hours worked, but just need the report to show the grand total of the week's hours. Have tried some calculations with textboxes but some work and some don't (one showed a negative number, but this was due to the hours worked being 6pm 12am, so I'm guessing you need to code it to say if it runs into the next day.
Are there any properties of the fields that need to be correct in order for this to work? I have made the start and finish times time/date types and because I have entered the worked hours out manually, this field type is a text.
Any Ideas?
Are there any properties of the fields that need to be correct in order for this to work? I have made the start and finish times time/date types and because I have entered the worked hours out manually, this field type is a text.
Any Ideas?