Formulas
 

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.

Formulas
 

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

"KB-1" wrote:

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.

Formulas
 

Hi KB,

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

HTH
Martin


"KB-1" wrote in message
...
Oh, by the way........it's Excel 2007

"KB-1" wrote:

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.

Formulas
 

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


"MartinW" wrote:

Hi KB,

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

HTH
Martin


"KB-1" wrote in message
...
Oh, by the way........it's Excel 2007

"KB-1" wrote:

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.

Formulas
 

Try this:

=MIN(44,A1)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"KB-1" wrote in message
...
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


"MartinW" wrote:

Hi KB,

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

HTH
Martin


"KB-1" wrote in message
...
Oh, by the way........it's Excel 2007

"KB-1" wrote:

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.

Formulas
 

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" wrote:

Try this:

=MIN(44,A1)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"KB-1" wrote in message
...
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


"MartinW" wrote:

Hi KB,

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

HTH
Martin


"KB-1" wrote in message
...
Oh, by the way........it's Excel 2007

"KB-1" wrote:

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.

Formulas
 

And we appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"KB-1" wrote in message
...
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" wrote:

Try this:

=MIN(44,A1)
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

"KB-1" wrote in message
...
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


"MartinW" wrote:

Hi KB,

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

HTH
Martin


"KB-1" wrote in message
...
Oh, by the way........it's Excel 2007

"KB-1" wrote:

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.