Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 06-03-2011
Member
 
Join Date: Mar 2011
Posts: 2
sad excel 2010 formula

I'm designing a time card,and at my wits end,and I need a little help.and only need one more formula.I'll use A as representing the first 2 wks,B as the 2nd 2wks and so on.Just as a reference.
What I need is a formula,that can calculated time over 80 hrs for a 2 wk period an able to carry it over to the next pay period.In one column I have my hrs worked.I need to keep track of my ot hrs,while at same time keeping my worked hrs at 80,if the worked hrs fall below 80 ,I would like to take it from the ot hrs and = to 80,and to be able to subtract the amount from the ot hrs and keep a running amount.
Reply With Quote
  #2  
Old 06-03-2011
Member
 
Join Date: Jul 2009
Posts: 628
Re: excel 2010 formula

Sorry dude, actually you have so many requirements and have not explained it properly. Am good enough in Excel formulas or could help you by searching on Google but what i need is an example of you exactly you want to do. So, could you give a rough screenshot about the same ?
Reply With Quote
  #3  
Old 06-03-2011
Member
 
Join Date: Mar 2011
Location: East London
Posts: 4
Re: excel 2010 formula

You need only the formula that can calculate time Wk period? just search it on google and you'll get an answer dude...........
Reply With Quote
  #4  
Old 06-03-2011
Member
 
Join Date: Mar 2011
Posts: 2
Re: excel 2010 formula

Quote:
Originally Posted by Theking View Post
Sorry dude, actually you have so many requirements and have not explained it properly. Am good enough in Excel formulas or could help you by searching on Google but what i need is an example of you exactly you want to do. So, could you give a rough screenshot about the same ?
Well dude,the attachment will explain it better than I can.Basically,what I WANT IS,if the single YELLOW cell IS BELOW 80,that it would take from the purple cell to make the yellow = 80.And the purple cell decreasing or increasing the same amount taken away from it. And if the yellow cell is more than 80,the amount over 80 will be added to the purple cell. And that totall will be carried over to the purple .TimeCard Sheet1.jpg

Rows A=Name,B=Date
A1=name,A2,A3 AND SO ON,SAME AS XL spreadsheet.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "excel 2010 formula"
Thread Thread Starter Forum Replies Last Post
Need formula help for MS Excel RlyPlyPanda MS Office Support 1 08-05-2012 01:46 PM
Excel 2010 - Help with making 'Standby' apply as 7.2 in formula - Possibly: Change Event (VBA) DMF Windows Software 1 09-02-2012 09:19 AM
Replace Microsoft Excel 2010 Worksheet name via formula and link it to other Tur^turro Windows Software 1 13-01-2012 05:09 PM
Excel Formula Scott2580 MS Office Support 2 15-02-2011 02:21 PM
Need help in excel formula Landon Software Development 2 27-10-2008 03:28 PM


All times are GMT +5.5. The time now is 06:41 PM.