Time sheet

[Closed]
Report
-
Posts
47367
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
-
Hello,
This is quite complicated to explain, therefore, I hope I don't confuse you. I am doing out timesheets. The criteria is as follows:

Time period: 07:00hrs to 22:00hrs, employee will be paid single rate hour i.e. if he/she works 8 hours, its 8 hours x 1 pay

Time period: 22:00hrs to 07:00hrs, employee will be paid double rate hour i.e. if he/she works 8 hours between these times, its 8 hours x 2 pay

Any ideas how to work this out

Cell C4 contains the start time of work and cell D4 contains the finish time of work.
If C4 = 21:00hrs, and D4 = 23:30hrs then the total time worked is 2hrs 30mins, however, the time after 22:00hrs is considered double time so this means the employee will get 4hours pay.

Could you help me out with doing an if function in excel?

Thanks, Karl


1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
have you used any good time sheets basic data. can you post a very small extract of the main sheet and explain with reference to that

google search give me some templates

https://www.vertex42.com/ExcelTemplates/timesheets.html
Posts
47367
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,116
Venkat1926 is back on the forum. Let's all cheer!