# Search:

Type: Posts; User: lezawang; Keyword(s):

Page 1 of 6 1

## Search: Search took 0.06 seconds.

by lezawang
Replies
6
Views
58

### Re: adding date using date() function

Thank you all. I got it. Very nice to see different styles. Thank you.

by lezawang
Replies
6
Views
58

### Re: adding date using date() function

Thank you that helps in that example but lets say if I want to add 1 year, 2 month, 3 days to a date. Can it be done using one function? Thank you once again

by lezawang
Replies
6
Views
58

### adding date using date() function

Hi
I have in cell A1=1/1/2019 and I want to add 1 year to that date. So I did this B1 = A1+date(1,0,0) but I got wrong answer

<tbody>
01/01/2019
02/12/2019

</tbody>
4. ## Thread: # of Mondays between 2 dates

by lezawang
Replies
1
Views
40

### # of Mondays between 2 dates

Hi
I was watching a video on how to calculate # of mondays between 2 dates. He used this formula

= networkdays.int(start date, end date, "0111111")

I understand 0111111 to show only Mondays,...
5. ## Thread: multiple total time by number

by lezawang
Replies
1
Views
38

### multiple total time by number

Hi I want to add time then multiple the result by rate which is 10.
So I have my time formatted as hh:mm
then I used =Sum(B1:B4) to find the total which is 21:00
Now I want to multiple 21:00 by 10...
6. ## Thread: text to time

by lezawang
Replies
5
Views
139

### Re: text to time

But why I need to re-enter them. They are already there. Let say I have 100 of them. Do I need to re-enter them again. Thank you very much.
7. ## Thread: text to time

by lezawang
Replies
5
Views
139

### Re: text to time

Thank you. But let me explain why I am confused about this. Let say A1 value is 1

I click on A1 and change the format to Short date, I will get 1/1/1900
then I click on the A1 again and I change...
8. ## Thread: text to time

by lezawang
Replies
5
Views
139

### text to time

Hi
I highlight cells A1:A3 and changed the format to Text. Then I entered time

<tbody>
1:00

2:00
9. ## Thread: selecting cells short cut

by lezawang
Replies
1
Views
71

### selecting cells short cut

Hi
I want to select let say 100 cells A1:A100. I can do that using mouse but I wonder of I can select A1 and then go to A100 and they are all selected. I select A1 and I can go to A100 using F5 and...
10. ## Thread: subtract time from rand()

by lezawang
Replies
2
Views
89

### subtract time from rand()

Hi
I want to generate random time. So what I tried is that

A1 = 24:00:00-rand()

But I got error message

but when entered the 24:00:00 in A1 and then in B1 I did this

B1 = A1 - rand()
11. ## Thread: convert time to fractions 1/24/ 2/24 etc

by lezawang
Replies
3
Views
63

### Re: convert time to fractions 1/24/ 2/24 etc

?/24 is amazing. Thank you so much.
12. ## Thread: convert time to fractions 1/24/ 2/24 etc

by lezawang
Replies
3
Views
63

### convert time to fractions 1/24/ 2/24 etc

Hi

I want to convert time to general (number). I want the numbers to be appeared like this 1/24, 2/24, 3/24,...., 24/24
I changed times to fractions format but I did not get what I want. In some...
13. ## Thread: saveas workbook in vba - default location

by lezawang
Replies
1
Views
59

### saveas workbook in vba - default location

Hi
I have saved a file in usb key. I opened the file from usb key. I ran the code below. I entered a new name, hello. The file was saved in C: drive under Documents, not in the usb key where the...
14. ## Thread: grouping sheets and inserting a picture/shape

by lezawang
Replies
0
Views
41

### grouping sheets and inserting a picture/shape

Hi
I wanted group several sheets and then insert a picture or shape in one sheet and hoping it will appear on all grouped sheets but when I group sheets, insert picture or shapes options are grayed...
15. ## Thread: printing all workbooks names in one shot

by lezawang
Replies
3
Views
100

### Re: printing all workbooks names in one shot

Thank you very much. The code is working perfect. I have 1 question please

Join(asName, vbLf)

Does that tell vba to join "each member" of the array with line feed? So I do not need to put that...
16. ## Thread: printing all workbooks names in one shot

by lezawang
Replies
3
Views
100

### printing all workbooks names in one shot

Hi
The code below is to print each workbook's name. If I have 5 then it will msgbox these 5 files names. I want to improve this code so it can print all the name in one shot (not 5 msgboxs or...
17. ## Thread: workbooks.open with file browser

by lezawang
Replies
2
Views
69

### workbooks.open with file browser

Hi

I want to improve the code below. I am thinking if it is possible to display file browser for the user to choose file from. Like when you click open in Excel, a file browser will be opened to...
18. ## Thread: how to become excel 365 insider

by lezawang
Replies
2
Views
96

### how to become excel 365 insider

Hi
I have office 365 student version. I went to to file-->acct as per the link below but I do not see Insider option.

https://insider.office.com/en-us/join
19. ## Thread: vlookup with approximate values

by lezawang
Replies
2
Views
64

### vlookup with approximate values

Hi
The vlookup = =VLOOKUP(B2,\$H\$2:\$I\$5,2,1) with approximate values is working if the table like this

This table start H2:I5

<colgroup><col width="64" span="2" style="width:48pt">...
20. ## Thread: reversing the order of 2 columns

by lezawang
Replies
7
Views
221

### Re: reversing the order of 2 columns

Thanks all for the help. Not prohibited but I thought there is another way I do not know off. Thanks all once again
21. ## Thread: reversing the order of 2 columns

by lezawang
Replies
7
Views
221

### reversing the order of 2 columns

Hi
Is there any way/trick to reverse a table without using sorting? Here is my table

From

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
average

by lezawang
Replies
1
Views
88

### adding 1 to a time (cross mid night)

Hi
I was watching a video on how to subtract 1:00 am from 11:00 pm (cross midnight). So the author added 1 to the am time and then subtract it from 11:00 pm.

Before adding 1 to 1:00 am, if I...
23. ## Thread: Excel convert time to Custom

by lezawang
Replies
1
Views
125

### Excel convert time to Custom

Hi

No matter how I enter the time in excel, excel will change the format to Custom (h:00:00 am/pm).
Why excel does not change the format of the time I entered to "Time" instead of "Custom" ?

...

by lezawang
Replies
1
Views
70

Hi
Can I say workbooks.add is the same if you open Excel program -->New ?
same thing workbooks.open is the same if you open excel program --> Open
Also, workbooks.close is the same thing if you...