Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 5th 05, 04:35 AM
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  
Old April 5th 05, 05:53 AM
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  
Old April 5th 05, 05:59 AM
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 03:18 PM
In Excel how can a number automatically display in text form Curtis A Excel Worksheet Functions 2 February 26th 05 11:31 AM
Excel Send To function problem kysiow Excel Discussion (Misc queries) 1 December 10th 04 01:37 AM
Excel function help facilities RPS Excel Discussion (Misc queries) 1 December 8th 04 02:36 AM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 06:27 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017