Hello,
Your help is greatly appreciated! Thank you in advance.
Cells
A2 9:00am
B2 7:00pm
C2 [please provide a formula that will automatically deduct a 1 hour lunch break]
D2 [please provide a forumla that will calculate time worked over 7 hours]
Hello,
Your help is greatly appreciated! Thank you in advance.
Cells
A2 9:00am
B2 7:00pm
C2 [please provide a formula that will automatically deduct a 1 hour lunch break]
D2 [please provide a forumla that will calculate time worked over 7 hours]
Hi,
C2:
Formula:
Please Login or Register to view this content.
D2:
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Manual calculation of time is difficult so it is better to calculate by using electronic gadgets.
time clock management software
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks