# need formula to calculate hours worked

1. ## need formula to calculate hours worked

Hi

how do i calculate the hours worked per shift

D

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

Please try this in Col C

=B2+1-A2

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

Perfect thank you

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

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..?

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

the hours dont add up correct though do they ?

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..?

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 ?

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

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

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

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

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

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)

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.``

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

@dougers1,

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1