Готовность: A= (Фактич.отработ.время)/(План.раб.время). The actual time worked can be calculated as the time during which the cell performed the RFP. To determine the time during which the cell was idle or performing the RFP, it is necessary to make a request to the database on the MS SQL server. The time interval during which the cell worked (idle) was calculated as the time from the moment of entering the status (RFP number or idle number) to the moment of entering the next status or until change (the end of the shift). After the change, the cell status should be automatically zeroed for subsequent re-entry. If during the technological or lunch breaks the cell status indicated the number of the performed RFP, then this time is not counted as time in work. The parameter “Planned working time” should be considered equal to 7.5 hours. If the cell has entered the status “idle due to the end of the shift”, then the parameter “planned working time” should be reduced by an amount equal to the difference in hours between the end of the work shift and the entry of this status.
I can not calculate the time to work with a single RFP in hours, for example, if the start time of work 2011-10-13 14: 19: 45.807 and ending 2011-10-13 07: 20: 43.257
