# need formula to calculate hours worked

1. ## need formula to calculate hours worked

Hi

how do i calculate the hours worked per shift

D  Register To Reply

2. ## Re: need formula to calculate hours worked

Please try this in Col C

=B2+1-A2  Register To Reply

3. ## Re: need formula to calculate hours worked

Perfect thank you  Register To Reply

4. ## Re: need formula to calculate hours worked

how would i calculate the total hours in a pivot by year/month as it not coming out what is should ?

see attached  Register To Reply

5. ## Re: need formula to calculate hours worked

Though it looks perfect to me, but I change the piviot layout by Year/Month total... is this what u r looking for..?  Register To Reply

6. ## Re: need formula to calculate hours worked

the hours dont add up correct though do they ?  Register To Reply

7. ## Re: need formula to calculate hours worked

its showing me the 4723:14:00 in both the sheets, which is correct... are u expecting something different..?  Register To Reply

8. ## Re: need formula to calculate hours worked

go to the data tab and add up the month of aug 2019 its not matching what pivot says ?  Register To Reply

9. ## Re: need formula to calculate hours worked

both data and piviot are showing 504:14:00 for Aug'19  Register To Reply

10. ## Re: need formula to calculate hours worked

yeah but it we count the hours manually - its not the total
01:00
10:59
12:15
12:15
11:00
12:15
11:15
11:30
12:15
12:15
12:15
12:15
12:15
12:15
12:15
12:15
12:15
12:15
12:15
11:00
12:00  Register To Reply

11. ## Re: need formula to calculate hours worked

Please use ABS(C2-B2) as the formula in D2 and drag and refresh the piviot..  Register To Reply

12. ## Re: need formula to calculate hours worked Originally Posted by amitmodi_mrt please use abs(c2-b2) as the formula in d2 and drag and refresh the piviot..
=abs(c2-b2)  Register To Reply

13. ## Re: need formula to calculate hours worked

Assuming that if finish time is less than Starting time, then finish time is the next day.
If finish time is greather than starting time, then both times are the same day
For that case this formula does the correct working times: ``Please Login or Register  to view this content.``  Register To Reply

14. ## Re: need formula to calculate hours worked

@dougers1,  Register To Reply