View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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