Solved how do i get excel to log my actual time work

May 11, 2013 at 11:21:41
Specs: Windows XP
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

See More: how do i get excel to log my actual time work

Report •

#1
May 11, 2013 at 14:54:25
✔ Best Answer
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 PM 

You 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:58

In cell K2 enter the formula: =J2-C2
which give the TOTAL hours worked with no breaks

In 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 Lunch

In 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

http://www.skeptic.com/


Report •

#2
May 21, 2013 at 14:50:38
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

Report •

#3
May 21, 2013 at 15:40:42
NOW DO I JUST CONTINUE TO COPY IT ALL THE WAY DOWN

As long as the rest of the rows are set up the same,
then yes, just drag down as many rows as needed.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question