time

[Trevor3007]

hi there


you would think my issue would not need 'me excel' but as much as i try , i cannot resolve.

my issue is to insert a start time ie 07o and end time ie 16:00. deduct 8 hrs and any over the 8 eight hrs is overtime payable at 1.5 hourly rate.

Saturday would be all the hours at 1.5 hourly rate and Sunday all the hours but at x 2 hourly rate.


PLEASE PLEASE can some kind person take up the challenge and sort for me.


many thanks to yee lords of excel.

Trevor3007

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1051520-timesheet-post5049786.html#post5049786

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).