Formulas

[Guest]

I am making a timesheet specific to my job and can't figure out how to do the
formulas.


I have my total hours for the week tallied up but I need formulas for the
following categories:

Total Regular Hours (44 or less)
Overtime Hours (44.01 or more)

The formulas I need are...I think:

If the weekly hours is less than 44, the Reg Hrs displays that amount of
hours and the O/T displays 0
If the weekly hours equal to 44 hrs then the Reg Hrs displays 44 and the O/T
Hrs displays 0
If the weekly hours is greater than 44 then the Reg Hrs displays 44 and the
O/T Hrs displays the difference.

I just don't understand how Excell does it.

Any help is greatly appreciated.

 

[Guest]

Oh, by the way........it's Excel 2007

 

[MartinW]

Hi KB,

With your total hours in A1 put this in B1
=MAX(A1-44,0)

HTH
Martin

 

[Guest]

Thanks MartinW, that worked great for the O/T hours.

What I still have is the total hours needed to be split between Reg hrs and
O/T hrs. I might be making this sound confusing.

I have:
Total Hours as say 60
Regular hours are 44
O/T hours are 16

You helped me get the O/T hours to read the 16 (or 0 if needed) with great
thanks. Now I need to get the Regular Hours to read the 44 or the amount
less than 44 if the Total Hours is less than 44.


for example:
Total Hours 40 Total Hours 48
Regular Hours 40 vs Regular Hours 44
O/T hours 0 O/T hours 4


Any ideas?

Thanks KB-1

 

[Ragdyer]

Try this:

=MIN(44,A1)

 

[Guest]

Thanks to the both of you for your help. I could figure it out on paper, in
other programs but couldn't understand Excel's mathematical lingo at all.
Big sigh of relief.

Again thank you very much
KB-1

 

[Ragdyer]

And we appreciate the feed-back.