S
sam13484 via OfficeKB.com
Very much a newbie when it comes to Excel.
I would like to know if there's a way to set up a spreadsheet that will
calculate:
Regular Time - up to 7.75 hours.
Time and a Half - next 2 hours.
Double Time - hours beyond the 9.75 above.
i.e.
Working 4 hours overtime:
7.75 hours - Regular Time
2 hours - Time and a Half
2 hours - Double Time
Being able to adjust the time segments, down to 15 minutes would be really
nice.
Thanks!
I would like to know if there's a way to set up a spreadsheet that will
calculate:
Regular Time - up to 7.75 hours.
Time and a Half - next 2 hours.
Double Time - hours beyond the 9.75 above.
i.e.
Working 4 hours overtime:
7.75 hours - Regular Time
2 hours - Time and a Half
2 hours - Double Time
Being able to adjust the time segments, down to 15 minutes would be really
nice.
Thanks!