snapshot of screen

For example if log in at 9a go to break at 10:15 - 30 lunch at 1-2 break again 3:15-3:30 clock out at 5 how do i get a formula to calculate at the end actual work time, i put an example of how i have it set up..thx

Try this: From your example your data is set up as:

A B C D E F G H I J 1) DOW DATE Time In Break Out Break In Lunch Out Lunch in Break Out Break In Time Out 2) Sat 05/11/2013 9:07 AM 10:15 AM 10:30AM 1:12 PM 2:12 PM 3:39PM 3:54 PM 5:35 PMYou will need to add three more columns like:

K L M N 1) Total Hrs Break Lunch Actual Hrs 2) 8:28 0:30 1:00 6:58In cell K2 enter the formula: =J2-C2

which give the TOTAL hours worked with no breaksIn cell L2 enter the formula: =SUM(E2-D2,I2-H2)

This gives us the Total Time used in the Two daily break periods.In cell M2 enter the formula: =G2-F2

This gives us the Total time used for LunchIn cell N2 enter the formula: =K2-(L2+M2)

This wraps everything up, and gives the Actual Time worked.See how that works for you.

MIKE

tHANK YOU SO VERY MUCH

NOW DO I JUST CONTINUE TO COPY IT ALL THE WAY DOWN IN ORDER FOR IT TO CONTINUE TO APPLY

NOW DO I JUST CONTINUE TO COPY IT ALL THE WAY DOWNAs long as the rest of the rows are set up the same,

then yes, just drag down as many rows as needed.MIKE

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History