i.e

I'm looking up the city UTC time zone. Some cities have negative numbers versus positive numbers. When it is found, I trying to convert the number into a time format (i.e. -5.5 = -5:30). However, when a number is negative and I convert it into a time format, the number is not being displayed...

Hello to all, I need to find a formula that will take two dates and two different time ( time in and time out) and subtract them to give me the time what was the balance used I.E Date time in date completed time out time used 5/1/2018 10 AM 5/2/2018 11: PM...

If there is data in a cell that is formatted as '3yrs 6ms 23ds' and links to another cell in another workbook and I want the cell in the other workbook to display this period in days i.e. 1302, what formulae would you use? Many thanks

Hello, I have 2 files. file 1 collects information from multiple files, just numbers. i want to be able to type in a person's name in file 1, and have it use that name in multiple formulas in that file to grab different cells in file 2. i.e. ='c:\temp\jonsmith_file.xlsx'!C1. I want to be...

Is there any way to scroll a frame on a userform when the screen used is a touchscreen? i.e. swipe to scroll, not tapping scroll bars.

Hi there, How do I search for a pattern of text in cell using VBA? I've looked into the instr and find method but this still eludes me. For example, I've got a list of clients with special IDs attached next to their names. (i.e. John Smith ABC1234). How do I search the cells to determine...

Hi all, I know this is a breeze for some of you, but I'm struggling a little. I have values in G3 and H3. I'm trying to calculate the following If G3 is < H3, make the cell appear blank with "" else If G3 / 2 is < G3 - H3 G3 / 2 else G3 - H3 i.e. G3 H3 14 6 Result of formula would be 7...

I have a Excel spreadsheet that consists of 6 worksheets. I include the following simply to provide a little background in preparation of asking a couple questions. The worksheets are as follows: Tennis Roster - max 20 players Schedule - For Tennis Doubles (i.e., 4 people needed to make up...

XLA used to be just the macro and no worksheets, but I cannot find a way to save XLSB without any Worksheets i.e. just the macro?

Hello, I’m looking for the total number of possibilities for a four digit entry where: 1. Available digits = 0,1,2,3,4,5,6,7,8,9. 2. Any single digit can only be used once. 3. Any combination of four digits are equal and only counted as one possibility (i.e., 0123, 3210, 1230, 2130 etc...

Hi guys! I like Excel a lot and have been using it for years, however always got through without pivot tables and relied just on formulas. Should still be the case with the following quest (SUMIF?), however I feel I have to try out a pivot table sooner or later. I have a somewhat easy...

Book1ABCDEFGH1Name1-Dec8-Dec15-Dec20-DecAverageCurrent week - Avg%2Cognizant$5$4$4$9$4$5108%3Credit Suisse$6$7$8$10$7$343%4Dominos$3$6$7$8$5$350%Sheet1 Column A have Name Date starts from Column B1 and is dynamic i.e. depending the no. of dates, the range will differ from B1 to X I want to...

Sir, I am getting 12 lakh rupees annual salary. While paying tax, for 1st 2.5 lakh tax is nil. For next 2.5 lakhs 5% tax i.e. 12,500. For next 5 lakh, 20% tax i.e. one lakh. Above 10 lakhs, 30% tax i.e. 60,000. So, I pay 0 + 12500 + 1 lakh + 60000 = 1,72,500. How can I compute through a formula...

Hello experts, Can you help me with VBA code for custom function to separate abcd1234efg12 into abcd 1234 efg 12 i.e. for every change from letter to numeric and viceversa adding space in between. Thanks.

Hi, Can anyone point me in the direction of an COVAR() tutorial/example that shows how the COVAR() function is calculated? I'm NOT looking for examples of how it's used, I'm looking for how it's CALCULATED using lower level functions i.e. SUM(), AVG(), COUNT(), multiplication and addition etc...

Hi Maybe somebody can help. I would like a formula that sums cells T3, Q3, N3 if the text "PP" is or "C" is found in the cell "A3" (I.E 200PP or 155C) but if "S" is found in "A3" then the value 45 is populated. Thanks for any help Stephen

Hi there, I currently use an IF formula to evaluate two cells, and return the data in the 1st cell if there is nothing in the 2nd, and the 2nd cell if it is populated; =IF(B1="",(A1),(B1)) Now I would like to do this across an array of cells, i.e. I would like the rightmost cell in a range to...

Hi, I want to have a formula that looks through a range of cells, and if a country is listed ( i.e United States) in a cell, then it will enter the 2 letter code in another cell (i.e US). This would apply for approximately 70 countries.

hi all just wondering what formula i can use to extract data from cell A1 "21" only? A1 = 21/02/2018 A2 = 7/2/2018 I have a large list of dates, but I just require the first part i.e. 21 in this case. You will notice, some numbers are two digits long, others are not. pls help?!

Looking to merge 2 cells in Range if there is data. i.e. Columns F:G Columns I:J