I have a table (tblTime) that tracks the amount of time someone spends working in a certain area. The field (tblTime.TimeEntered) is defined as a Short Time field. Data entered might be:
DateEntered TimeEntered Area
7/1/11 1:10 Marketing
7/1/11 2:00 Administration
7/1/11 1:30 Management
7/1/11 1:10 Logistics
7/1/11 1:10 Personal
7/1/11 1:00 Vacation
In this example, the daily total would be 8:00. I have this working as =Sum([TimeEntered])
Next, I need to calculate the percentage of an 8 hour day that this total is. In this case, I need to see that 8:00/8 hours per day is 100%. In the text box, I have =(Sum([TimeEntered])/8). This returns 1:00. Almost close enough, but I'd like to get this to display 100% instead of 1:00. Changing the format of the text box doesn't work. Is there a way to do this?
Anna Jaeger
iMIS Database Support
DateEntered TimeEntered Area
7/1/11 1:10 Marketing
7/1/11 2:00 Administration
7/1/11 1:30 Management
7/1/11 1:10 Logistics
7/1/11 1:10 Personal
7/1/11 1:00 Vacation
In this example, the daily total would be 8:00. I have this working as =Sum([TimeEntered])
Next, I need to calculate the percentage of an 8 hour day that this total is. In this case, I need to see that 8:00/8 hours per day is 100%. In the text box, I have =(Sum([TimeEntered])/8). This returns 1:00. Almost close enough, but I'd like to get this to display 100% instead of 1:00. Changing the format of the text box doesn't work. Is there a way to do this?
Anna Jaeger
iMIS Database Support