Hi
how do i calculate the hours worked per shift
D
Hi
how do i calculate the hours worked per shift
D
Please try this in Col C
=B2+1-A2
Perfect thank you
how would i calculate the total hours in a pivot by year/month as it not coming out what is should ?
see attached
Though it looks perfect to me, but I change the piviot layout by Year/Month total... is this what u r looking for..?
the hours dont add up correct though do they ?
its showing me the 4723:14:00 in both the sheets, which is correct... are u expecting something different..?
go to the data tab and add up the month of aug 2019 its not matching what pivot says ?
both data and piviot are showing 504:14:00 for Aug'19
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
Please use ABS(C2-B2) as the formula in D2 and drag and refresh the piviot..
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.
Kind regards,
Piet Bom
@dougers1,
Was this what you wanted ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks