Employee A is paid a base monthly salary of $1,000. She will receive a bonus
of $100/night over four nights a month. She will receive another bonus of
$49/hour for every hour over 144 hours.

Column D is the $100/night and Column B is the $49/hour.

I am new at this.

How is the time/work hours recorded?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...
Employee A is paid a base monthly salary of $1,000. She will receive a
bonus
of $100/night over four nights a month. She will receive another bonus of
$49/hour for every hour over 144 hours.

Column D is the $100/night and Column B is the $49/hour.

I am new at this.

Time and work hours are recorded in Excel and totalled at the end of the
month.
"Sandy Mann" wrote:

How is the time/work hours recorded?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...
Employee A is paid a base monthly salary of $1,000. She will receive a
bonus
of $100/night over four nights a month. She will receive another bonus of
$49/hour for every hour over 144 hours.

Column D is the $100/night and Column B is the $49/hour.

I am new at this.

Patient Visits by NP
Salary Paid BONUS TOTAL
7,125.00 100 7,225.00

LOCATION #3
Patient/Room # Time spent Date Night Call Dr. 1 Dr.2 Dr. 3 Dr. 4
Thunderstorm #108 0.5 12-Oct 1
Tornado #218 0.25 12-Oct 1
Earthquake #100 0.9 12-Oct 1
Tsunuami #500 0.5 12-Oct 1
Rain Sunny #800 1.5 12-Oct 1

























3.65 1 2 1 1 5 Total Number of Encounters

0.2 0.4 0.2 0.2 % of Total

1445 2890 1445 1445 Salary Allocation by Physician



"Sandy Mann" wrote:

How is the time/work hours recorded?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...
Employee A is paid a base monthly salary of $1,000. She will receive a
bonus
of $100/night over four nights a month. She will receive another bonus of
$49/hour for every hour over 144 hours.

Column D is the $100/night and Column B is the $49/hour.

I am new at this.

Still not too much detail but assuming that:

1: Cell C1 holds 49
2: Cell D1 holds 100
3: Cell C40 has the total hours worked that month
4: Cell E40 had the numnber of nights

Then try:

=1000+MAX(C40-144,0)*B1+MIN(E40,4)*D1

However, it would be better to put the 1000, 144 & 4 in other cells and then
refer to that cell so that when something changes you only have to change
that one cell and all formulas will use the new value.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...

Time and work hours are recorded in Excel and totalled at the end of the
month.
"Sandy Mann" wrote:

How is the time/work hours recorded?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...
Employee A is paid a base monthly salary of $1,000. She will receive a
bonus
of $100/night over four nights a month. She will receive another bonus
of
$49/hour for every hour over 144 hours.

Column D is the $100/night and Column B is the $49/hour.

I am new at this.

Did you see the worksheet I sent you?
"Sandy Mann" wrote:

Still not too much detail but assuming that:

1: Cell C1 holds 49
2: Cell D1 holds 100
3: Cell C40 has the total hours worked that month
4: Cell E40 had the numnber of nights

Then try:

=1000+MAX(C40-144,0)*B1+MIN(E40,4)*D1

However, it would be better to put the 1000, 144 & 4 in other cells and then
refer to that cell so that when something changes you only have to change
that one cell and all formulas will use the new value.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...

Time and work hours are recorded in Excel and totalled at the end of the
month.
"Sandy Mann" wrote:

How is the time/work hours recorded?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...
Employee A is paid a base monthly salary of $1,000. She will receive a
bonus
of $100/night over four nights a month. She will receive another bonus
of
$49/hour for every hour over 144 hours.

Column D is the $100/night and Column B is the $49/hour.

I am new at this.

Did you see the worksheet I sent you?

No. Did you click on the Reply button? If you did then it would have gone
to mailinator.com which is a spam trap that I do not check. Please resent
it to:

sandymann2 at_sign tiscali.co.uk

making it into a real address .

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...

Did you see the worksheet I sent you?
"Sandy Mann" wrote:

Still not too much detail but assuming that:

1: Cell C1 holds 49
2: Cell D1 holds 100
3: Cell C40 has the total hours worked that month
4: Cell E40 had the numnber of nights

Then try:

=1000+MAX(C40-144,0)*B1+MIN(E40,4)*D1

However, it would be better to put the 1000, 144 & 4 in other cells and
then
refer to that cell so that when something changes you only have to change
that one cell and all formulas will use the new value.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...

Time and work hours are recorded in Excel and totalled at the end of
the
month.
"Sandy Mann" wrote:

How is the time/work hours recorded?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...
Employee A is paid a base monthly salary of $1,000. She will
receive a
bonus
of $100/night over four nights a month. She will receive another
bonus
of
$49/hour for every hour over 144 hours.

Column D is the $100/night and Column B is the $49/hour.

I am new at this.

Still nothing's come through.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
Did you see the worksheet I sent you?

No. Did you click on the Reply button? If you did then it would have
gone to mailinator.com which is a spam trap that I do not check. Please
resent it to:

sandymann2 at_sign tiscali.co.uk

making it into a real address .

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...

Did you see the worksheet I sent you?
"Sandy Mann" wrote:

Still not too much detail but assuming that:

1: Cell C1 holds 49
2: Cell D1 holds 100
3: Cell C40 has the total hours worked that month
4: Cell E40 had the numnber of nights

Then try:

=1000+MAX(C40-144,0)*B1+MIN(E40,4)*D1

However, it would be better to put the 1000, 144 & 4 in other cells and
then
refer to that cell so that when something changes you only have to
change
that one cell and all formulas will use the new value.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...

Time and work hours are recorded in Excel and totalled at the end of
the
month.
"Sandy Mann" wrote:

How is the time/work hours recorded?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"chickieram" wrote in message
...
Employee A is paid a base monthly salary of $1,000. She will
receive a
bonus
of $100/night over four nights a month. She will receive another
bonus
of
$49/hour for every hour over 144 hours.

Column D is the $100/night and Column B is the $49/hour.

I am new at this.