Remember Me?

#1
April 5th 05, 04:35 AM
 Nick Pettiet Posts: n/a
excel: How do I setup a function to put any numbers over 80 into .

I am trying to setup a payroll spreadsheet for a 2 week period. I would like
once my total for an employee exceeds 80 hours to put the additional hours
over 80 into a seperate overtime pay cell. Any suggestions?

#2
April 5th 05, 05:53 AM
 Biff Posts: n/a

Hi!

Try something along these lines:

For straight time:

=MIN(SUM(Time_Range),80)

For OT (over 80):

=MAX(0,SUM(Time_Range)-80)

Biff

-----Original Message-----
I am trying to setup a payroll spreadsheet for a 2 week

period. I would like
once my total for an employee exceeds 80 hours to put the

over 80 into a seperate overtime pay cell. Any

suggestions?
.

#3
April 5th 05, 05:59 AM
 Richard Reye Posts: n/a

Nick,

From my understanding, you need to columns. One for total hours under or
equal to 80 and one for total hours over 80. In the <=80 cell use this formula

=IF(SUM(MyRange)80,80,SUM(MyRange))

and in the 80 cell use

=IF(SUM(MyRange)80,SUM(MyRange)-80,0)

Replace MyRange with the cells you add to get total hours

Cheers!

"Nick Pettiet" wrote:

I am trying to setup a payroll spreadsheet for a 2 week period. I would like
once my total for an employee exceeds 80 hours to put the additional hours
over 80 into a seperate overtime pay cell. Any suggestions?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Nigel Welch Excel Worksheet Functions 4 March 4th 05 03:18 PM Curtis A Excel Worksheet Functions 2 February 26th 05 11:31 AM kysiow Excel Discussion (Misc queries) 1 December 10th 04 01:37 AM RPS Excel Discussion (Misc queries) 1 December 8th 04 02:36 AM Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM

All times are GMT +1. The time now is 04:56 AM.