Time sheet

Closed
Karl - 31 Mar 2011 à 04:26
Ambucias Posts 47312 Registration date Monday 1 February 2010 Status Moderator Last seen 28 March 2026 - 31 Mar 2011 à 06:33
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


Related:

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
31 Mar 2011 à 06:30
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
Ambucias Posts 47312 Registration date Monday 1 February 2010 Status Moderator Last seen 28 March 2026 11,166
31 Mar 2011 à 06:33
Venkat1926 is back on the forum. Let's all cheer!