Functions
in [Excel]
|
CONVERT TIME FROM 4:30 TO 4.5 I'm tring to convert a time ie. 4:30 to a interger ie. 4.5. can anyone help? ... 27 May 2010 18:11
If statement linking data from one sheet to another I have a spreadsheet with many tabs. I am trying to develop a summery sheet that will 'auto fill' certain rows of data and still remain dynamic. What I am doing: in Column I, I have a number; I want this to be the row number for finding the data in the other worksheet. I have If Statements in Columns A th... 27 May 2010 18:11
arquivo excel worksheet boa noite recebi o arquivo excel worksheet e nao consigo abrir, e quando tento abrir aparece esta mensagem: microsoft excel viewer cannot open files of this type ... 27 May 2010 18:11
Count digits before decimals and after decimals Dear expert, Would like to count the digits before decimals and after decimals. For example, 111975.35 should be 6 digits before decimals and 2 digits after decimals 12456.25 should be 5 and 2 2478.24 should be 4 and 2 248.37 should be 3 and 2 Using LEN does not help. Can you help please? ... 27 May 2010 21:29
One step paste of XLS file name in one of its own cells Is there a way to automatically paste the file name of an open excel file into one of its own cells. I can paste the file name of a Word Document with a couple of easy steps into a Word document but cannot find a way to do so in Excel. Thanks SeeThomas ... 27 May 2010 17:05
IF AND VLOOKUP formula needed I need to do a formula where I need to determine if the size of C12 or C13 is greater or less than E12 or E13 respectively. Knowing that I need for the formula to do a vlookup into the "Non Direct Care" tab and if there is an "x" in column J to multiply the value in cell B12 or B13 times the values in J3 or J4 ... 27 May 2010 18:11
One step paste of XLS file name in one of its own cells Hi, Put this formula in a cell. It only works if the workbook has been saved =MID(CELL("filename",A1),1+FIND("[",CELL("filename",A1)),FIND(".",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assum... 27 May 2010 20:23
How do I alphabetize the tabs on a spreadsheet with 25 tabs? Hi, Alt+F11 to open vb editor. Right click 'ThisWorkbook' and insert module and paste the code below in and run it Sub Sortem() For x = 1 To Worksheets.Count For y = x To Worksheets.Count If UCase(Sheets(y).Name) < UCase(Sheets(x).Name) Then Sheets(y).Move Before:=Sheets(x) ... 27 May 2010 17:05
create overtime spread sheet I wish to have a cumulative hours column and a date column. So the hours are scaled upwards and the column associated with a person and a date to show who did the youngest to go below anybody on the same hours. e.g. Tom had 12 hours did overtime (12 hours) yesterday, John had 24 hours when inputed how could you... 27 May 2010 17:05
Excel - Convert int value secs past midnight into time 53100=2:45 Hi, with your seconds in a1 =A1/(24*60*60) and format as time (hh:mm:ss) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Zuly" wrote: How do convert an int value of seconds... 27 May 2010 17:05 |