harveya915
Board Regular
- Joined
- Sep 4, 2015
- Messages
- 141
I created a time sheet to keep track of my hours worked. My time sheet begins on the Saturday after Friday (payday) and is 2 weeks long. For example if I get paid on Friday, July 2 then the next pay period begins on Saturday July 3 through Friday July 16. I have the sheet calculate on a daily basis how many hours worked for that day and it subtotals how many hours worked in total. Based on a 8 hour work day, 80 hours/pay period, I need an equation to tell me how many hours I'm short or how many hours extra hours I have depending on the most recent hours that were input. For example let's say I worked 7 hours on Monday and Tuesday and worked 6 hours on Wednesday, so I have accumulated 20 hours in 3 days, however by the end of the day on Wednesday i should be at 24 hours, therefore I am 4 hours short.
Thanks for any input.
Thanks for any input.