Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    6
    Views
    58

    Re: adding date using date() function

    Thank you all. I got it. Very nice to see different styles. Thank you.
  2. 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
  3. 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. 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. 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. 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. 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. Re: convert time to fractions 1/24/ 2/24 etc

    ?/24 is amazing. Thank you so much.
  12. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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
    grade
  22. 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. 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" ?

    ...
  24. Replies
    1
    Views
    70

    workbooks.add, open and close

    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...
  25. Replies
    4
    Views
    153

    VBA code already there in brand new file

    Hi
    I closed all excel files. I opened a new one by clicking on excel icon. I go to VBA editor and I see some codes there? Why and from where they came? Thank you very much.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4