Overtime calculations
I don't know of any read-made solutions, but the calculations you're looking
to do are pretty simple algebraic/logic calculations which can be
accomplished with Excel's built-in functions.
No need for programming here.
Total hours worked is just a sum of a range.
Total hours less lunch is a sum of a range less another value.
Etc.
Since your needs are so specific, I would doubt there is a ready-made
template for this, however, as I say, these are calculations that can be done
in Excel without any programming knowledge.
--
Brevity is the soul of wit.
"kozzzle" wrote:
I need to keep track of my work times. I just want to input the start time,
finish time and lunch break. After that I would like the sheet to calculate
the following
Total Hours worked
Total Hours worked less lunch break
Overtime after 8 hours calculated at 1.5
Overtime calculated after 10 hours at double time.
Overtime Saturday calculated at 1.5 for the first 2 hours then double time
for the remainder
Overtime Sunday calculated at double time.
I have looked everywhere for a program to do this, or a template that I can
do it with Excel, but so far no good. Can anyone tell me where I could find
this? Please bear in mind that I am not a programmer and am looking for a
ready made solution.
Thanks
|