# kind

1. ### time calculation on working hours less weekend

Hi I am Struggling to solve this! I need to calculate time between two dates, but need to be only between 8:00 AM and 5:00 PM, excluding weekends. I got some results, but when the start time is over 5:00 pm still add the time... example below: Start End Transmission time (h:mm) 28/09/2019...
2. ### how to IF this kind of condition

<tbody> IN AM OUT AM IN PM OUT PM Return 1 1 1 1 TRUE 1 1 0 0 TRUE 0 0 1 1 TRUE 1 0 0 1 TRUE 1 0 0 0 FALSE 0 1 0 0 FALSE 0 0 1 0 FALSE 0 0 0 1 FALSE 1 0 1 1 FALSE 1 1 0 1 FALSE 1 1 1 0 FALSE </tbody> how to make the formula with that kind of combination then will...
3. ### How to convert lots of columns of data all into just one column easily?

Hello, Thanks for reading. I have columns of data from column C right through to column WZZ. What I want to do is to put all of this data into column A only. Each column has the exact same amount of rows - data starts at row 6 and finishes at to 2,500. Is there a qucik way to do this...
4. ### Excel online

Hi There, Ive been searching the internet and cant find a decent answer to the following and wondered if someone would be kind enough to help? Can Excel online work with macros Eg can a button be created that will start a macro to do a series of tasks. Kind Regards P
5. ### Formula should work, but isnt. Text / Values / Hour challenge.

Hello friends, hope all is well! Please help me =IF(TEXT(INT(\$D3*24)-HOUR(\$C1),"0")=2,TRUE,FALSE) keeps giving me False. Even though the result of TEXT(INT(\$D3*24)-HOUR(\$C1),"0") gives me 2. Your kind help is needed and always appreciated in advance.
6. ### Convert To VBA

I have a MS Excel formula in a cell that I'd like to convert to VBA in order to use in MS Access. Would one you experts be so kind as to convert this formula into a VBA function. =LEN(SUBSTITUTE(C3, " ", "")) Thank you so much.
7. ### Printing workbook

I may regret trying to do this myself, but I dont know til I try... First off, I dont know VBA code, but there are some people here who do, so this may turn into a reference thread for them to accomplish this, unless I can somehow manage to get it done with help from forum members who are waaay...
8. ### PowerBI Dataflows (cant see it in the service)

Hi all, I work at a school and got a (probably educational) powerbi pro license. I want to experiment with powerbi dataflows but cannot see the functionality in the powerbi online service. Anyone knows why? Kind regards, MrJoosten
9. ### Topics selection macro.

Is there anyway i can populate a new page to show some kind of filtered information based on whether a series of cells are populated yes or no. I want to have a list of cells that each have the option "yes" or "no". I then want to be able to run a macro or some kind of automation where it...
10. ### insert date + 2,

hi, I have a date in A2 & if C2 = Yes, then D2 = A2 + 1, however the date in D2 must not be a weekend . Example A2 = 22/3/19 , C2 = Yes then D2 would return 25/3/19 etc. The full range is A2:K200 Can some kind person solve for me? MTIA KR Trevor 3007
11. ### Extract Variable Text String

Ok, I got a bunch of data rows with the following kind of data: FACILITYID</td><td>H1676</td></ FACILITYID</td><td>PN1354</td> FACILITYID</td><td>61523/54712</ ... and so on. I need to extract the unique data, no matter the length, from each cell. Unfortunately, a lot of characters like "<"...
12. ### Formula that receives array as input and gives ranking as output

Hello, everyone, I'm looking for a formula which when inserted in a SINGLE cell would return {1,2,3,4,5,6} for the array below <tbody> 55 45 32 21 21 21 </tbody> I tried the formula below, but it doesn't deal well with duplicates: Thanks! Kind regards, ORoxo
13. ### Open a File in sharepoint

Hi there, I have managed to open files and lookup files in shared drives before but i don't know how to reference this to open a file in a sharepoint. Can anyone help to point me in the right direction. Any help is greatly appreciated. Kind regards, Forrestgump
14. ### macro to copy text

Hello at work we are using one program that basicly tells us what kind of variants to use for some specific objects for example : https://imgur.com/a/ug8OcaT The macro needs to copy from column : AO(V1) to CP(V54) [AO,AP,AQ,AR,AS....ETC] only the last three numbers and then only the last letter...
15. ### formula only work if other cell has data

Hi all, Could anyone help me with this formula below, I would likeit to only calculate and return “SPARE/VOR” if D78 is not blank but I have noidea where to nest it in the formula but not for want of trying :( would it be =NOT(ISBLANK)? If someone would be so kind as to add it to the formula...
16. ### Merge and Unmerge Excel

​Hi, I had a file downloaded from somewhere, 3 rows were merged, when i perform unmerged, first and second row was file with data, how could this be done and what is the purpose of this ? Appreciate your kind answer and thank you BR//TE
17. ### Cell Formatting

I am looking at the following in Cell D1. Surveying Services shall be provided for the following scopes: - Sitework and grades - Set demo removal limits - Centerline control points - Benchmarks So, it appears there is some kind of formatting going on that allows these line items to drop down a...
18. ### Access: Macro Requery Control Name

When you go to create a Macro, based on an Event, there is a selection for "Requery" When you select that it comes up with a filed below it titled "Control Name". It appears that it wants the user to enter some kind of information. What is the Control Name and what kind of information/data is...
19. ### Delete row if #REF! shown

Hi, I am using this simple code =DATABASE!A202 & son on. I have noticed that if nothing is in the cell in question then on the worksheet where there should be a value etc i see #REF ! Can we use some kind of code so that row is then deleted should #REF ! be in any cell in Column A Thanks
20. ### How to change other cell value

Hello fellows. I have a doubt on Excel calculation. If I change the A1 value the B1 should automatically change to 1 the same if suppose I change B1 value the A1 should change to 1 Kind Regards

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...