Click here for important information about Computing.net.

A2 = hh:mm (previous total work hours)

B2 = hh:mm (new total work hours)

C2 = formula to find the % of increase or decrease between the two work hours.D2 = h:mm:ss (start time of the course)

E2 = h:mm:ss (end time of the course)

F2 = formula to find the % of the time it took the employee to complete the courseG2 = hh:mm (total work hours)

H2 = hh:mm (total unproductive hours)

I2 = formula to find the % of unproductive hours from the total work hours

J2 = formula to find the % of unproductive hours against 8 hours only (standard work hours)

Times are stored as numbers within Excel. The standard percent related formulas should work just fine. For A2:C2:

Percent change formula:

=(A2-B2)/B2 formatted as a percentage.

For D2:F2:Don't we need a cell for the 3rd value - the time it took the employee to complete the course?

For G2:J2Percent of formula:

=(Partial/Whole)*100 formatted as a percentage

=(H2/G2)*100

=(H2/8)*100

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Ask Your Question

Weekly Poll

Do you think Intel's new hybrid chips will better compete with Apple/ARM?

Yes (14) | ||

No (14) | ||

I don't know (15) |

Discuss in The Lounge

Poll History