Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Nick Pettiet
 
Posts: n/a
Default 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   Report Post  
Biff
 
Posts: n/a
Default

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

additional hours
over 80 into a seperate overtime pay cell. Any

suggestions?
.

  #3   Report Post  
Richard Reye
 
Posts: n/a
Default

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where is DateDiff function in Excel 2002 ? Nigel Welch Excel Worksheet Functions 4 March 4th 05 04:18 PM
In Excel how can a number automatically display in text form Curtis A Excel Worksheet Functions 2 February 26th 05 12:31 PM
Excel Send To function problem kysiow Excel Discussion (Misc queries) 1 December 10th 04 02:37 AM
Excel function help facilities RPS Excel Discussion (Misc queries) 1 December 8th 04 03:36 AM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 11:49 AM


All times are GMT +1. The time now is 09:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"