calculating time Hi, I have to calculate the following Employee job in must be 9:00 am, but employee arrived 8.53 am. Which formula must I use to calculate the 7 min ? ... 25 Mar 2010 12:40 EXCEL 2003 - SUBTOTALS After using the subtotal command, I want to format the spreadsheet by inserting blank lines before and after each subtotal and grand total. How can I do this without manually inserting blank lines; or how can I create a template with blank lines inserted after each subtotal? -- RCF ... 25 Mar 2010 16:16 Cell Navigation how can i force cell navigation in a specific order via the tab key? i have done this before but it has been a while and i can't remember how i did it. thanks for helping. ... 25 Mar 2010 16:16 Automatically extend a list when adding a new data to another list Hi, I could not find the solution to my problem in the questions asked so here we go: I have two lists, color and type: Color: Red, Blue, Green Type: A, B, C From this I would like to create a third list showing me all combinations of "color" and "type" (eg. RedA, RedB... =[color]&[type]). I want the ... 25 Mar 2010 11:30 plz solve this i need solution total average result RANK 544 54.4 fail FAIL 593 59.3 pass 10 637 63.7 pass 6 611 61.1 fail FAIL 627 62.7 fail FAIL 632 63.2 pass 7 686 68.6 pass 2 653 65.3 pass 4 653 65.3 pass 4 713 71.3 pass 1 654 65.4 pass 3 what i need is i would like to give rank to only pass student not to fail student ...n rank in... 25 Mar 2010 11:30 plz solve this i need solution guys, i have a student record and for that i calculate total,avg and result but the problem is rank ....what i need is i would like to give the rank to only pass student in sequence. but for the fail its show fail....any formula ...plz see the attechment for this......... ... 25 Mar 2010 11:30 Summary sheet including only open projects. Have a workbook with 2 worksheets. Main worksheet contains all projects, opened, cancelled and closed. Contains columns A-Q. Column Q is entitled "Complete". Valid entries in the column appear to be cancelled, yes or blank. They want the second worksheet to contain only current projects and only columns A... 25 Mar 2010 10:19 Why am I getting this VBA error? I'm getting error 13 "type mismatch" when I run the below code. I've tested it on a small new excel sheet and it work fine. There are no other macros in my excel sheet so no conflicts. Any ideas? I'm trying to hide all rows were the value in column A of that row is blank / 0. Sub blank_rows() Dim ws As W... 25 Mar 2010 10:19 Random Numbers I am wanting to generate random numbers from 1 to 20 in cells A1 to A20, but have no duplicates. How can I do this? ... 25 Mar 2010 13:50 Formula from consecutive rows to alternate rows? I have a worksheet with data in consecutive rows. I have another worksheet into which I want to insert a formula on every second row, but referring to each consecutive row in the first worksheet. For example, on Worksheet 1, in column A: Row 1: 123 Row 2: 456 Row 3: 789 etc On Worksheet 2 I want to sho... 25 Mar 2010 10:19