ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   time sheet determination of what day and time rate (https://www.excelbanter.com/excel-worksheet-functions/109489-time-sheet-determination-what-day-time-rate.html)

Oldjay

time sheet determination of what day and time rate
 
..I want to set up a time sheet that uses straight time rate between 8am and
5pm on Monday thru Friday. Time and one half after 5pm on Monday thru Friday
and all day Satruday. double time on Sunday. Then it adds all the hours up
and multiplies the result by a dollar cost. The worker would just put in the
date and hours worked. He would put in two entries each day One before lunch
and one after lunch (if he worked long enough to have a lunch).

oldjay

Toppers

time sheet determination of what day and time rate
 
Take a look he

http://office.microsoft.com/en-gb/re...uery=timesheet

"Oldjay" wrote:

.I want to set up a time sheet that uses straight time rate between 8am and
5pm on Monday thru Friday. Time and one half after 5pm on Monday thru Friday
and all day Satruday. double time on Sunday. Then it adds all the hours up
and multiplies the result by a dollar cost. The worker would just put in the
date and hours worked. He would put in two entries each day One before lunch
and one after lunch (if he worked long enough to have a lunch).

oldjay



All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com