#1
 
 
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. 
#2
 
 
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 ? 
#3
 
 
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........... 
#4
 
 
Re: excel 2010 formula Quote:
Rows A=Name,B=Date A1=name,A2,A3 AND SO ON,SAME AS XL spreadsheet. 

Tags: excel, excel 2010, excel fomula, ms office 
Thread Tools  Search this Thread 

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