Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: I'd like to make a FOOD schedule spread sheet

    This calculates as follows.
    If you entered three of your meal times then it first calculates the difference between first and second meal and then the difference between third and second meal. Then...
  2. Re: I'd like to make a FOOD schedule spread sheet

    Sorry for being late.
    But, I hope now, it works for you.
    here is the link for your workbook.
    https://drive.google.com/file/d/1sbAkdXyJeN0yRliZbjaeIj8yqwfTMD7B/view?usp=sharing
  3. Re: I'd like to make a FOOD schedule spread sheet

    Wow! So sweet of you.
    I really appreciate it. By the way, I left Canberra last year. I am now in the US.

    As soon as I get some extra time, I will work on your problem and provide the solution...
  4. Re: I'd like to make a FOOD schedule spread sheet

    It is absolutely possible. For simplicity, I did use the midnight format.
  5. Re: I'd like to make a FOOD schedule spread sheet

    I have referenced 12:00 midnight as base in the formula. So I advise not to use 12:00 instead use 12:01.
    This will solve the problem.
    And, yes, one row is for one day for the current formula.
  6. Re: Is it possible to define a name which consists text with double quotes?

    Thank you Rick Rothstein for this awesome solution.
  7. Re: I'd like to make a FOOD schedule spread sheet

    Here is the solution.
    Please make sure, if your time goes beyond midnight, you enter that time into the next day.

    ...
  8. Replies
    9
    Views
    196

    Re: Help with CHOOSE function

    DanteAmor

    Sorry for the misunderstanding. Yes the way FormR suggested works fine.
    At first I was looking to give those values to CHOOSE as a named range.
    Then you suggested to use INDEX, I...
  9. Replies
    9
    Views
    196

    Re: Help with CHOOSE function

    No.
    I was talking about Excel Formula not a macro or VBA.
    ��
  10. Replies
    9
    Views
    196

    Re: Help with CHOOSE function

    Thank you so much for both of you for your effort.
    I really appreciate it.
  11. Re: I'd like to make a FOOD schedule spread sheet

    Text being partly hidden is just the problem of some formatting on cell alignment.
    Here is the link for the file.
    https://drive.google.com/file/d/1LqSHPBksPEcVGWRaNMGVgIVxZuS0FjRC/view?usp=sharing...
  12. Re: I'd like to make a FOOD schedule spread sheet

    Here is the link of your file.
    https://drive.google.com/file/d/1Uz9jQJebuIOjfRzB8ug2iKbJwlhfL-W9/view?usp=sharing

    Make sure you enter your time to every column you have created to get the better...
  13. Replies
    9
    Views
    196

    Re: Help with CHOOSE function

    I tried that approach too. That didn't work.
    If I hardcode the array inside Index, it works, but when I put the Name, It gives #REF error.
    Any more thought on it?
  14. Re: I'd like to make a FOOD schedule spread sheet

    Use this formula to cell AH3

    =AVERAGE(F3-B3,J3-F3,N3-J3,R3-N3,V3-R3,Z3-V3,AD3-Z3)
    It gives your average hours and minutes of that day in time format.
    Take average of the column at the end of the...
  15. Replies
    9
    Views
    196

    Help with CHOOSE function

    CHOOSE function has syntax

    CHOOSE(index_num, value1, [value2], ...)

    I have 100s of values (text values) to deliver to CHOOSE function. Instead of typing all those values every time, I want to...
  16. Re: Count rows that contain multiple values in multiple columns

    This formula fails when a number repeats and another number is absent. How can this problem be addressed?
    I am here just to learn something. This may not be the requirement of the original question....
  17. Is it possible to define a name which consists text with double quotes?

    Hi,

    I have a requirement in my formula that certain strings gets repeated. I want to put that string as a defined name. Here is an example of such string:


    " One"," Two"," Three"," Four","...
  18. Re: Adding Cricket Overs with VBA with parameters

    Hi @Fluff

    Can JackDanIce's VBA be modified so that the function AddOvers() can take arguments as SUM function takes?
  19. Re: Adding Cricket Overs with VBA with parameters

    Thank you both for the answers.
    The built in function DOLLARFE and DOLLARDE works quite bit. But I have to click every cell I want to add.
    The VBA given by JackDanIce also adds up a contagious...
  20. Adding Cricket Overs with VBA with parameters

    Hi

    In Cricket Sports there are 6 legal balls a bowler bowls towards the batsman. Those 6 balls are called an over.
    So, the sequence of the balls are counted as follows.
    1 ball = 0.1 overs
    2...
  21. Replies
    11
    Views
    353

    Re: Sum non adjacent cells with criteria

    I am getting Run-time Error 1004
    Application defined or object defined error

    When I click Debug, it yellow highlights line
    c.Offset(, 2).Value = c.Offset(, 2).Value + f.Offset(n, 1).Value
    ...
  22. Re: Small VBA code needed for delete with criteria

    I am very sorry. At first I gave you the wrong/opposite criteria.
    I am able to fix that by replacing <> with an = sign.
    That worked great.
    Thank you Joe again.

    Now, can I make this macro run...
  23. Re: Small VBA code needed for delete with criteria

    I am sorry. I give you the opposite criteria. I have to delete the ranges if the criteria is empty or equals to "".
  24. Re: Small VBA code needed for delete with criteria

    Hello Joe

    Yes, there is absolutely a rhyme.
    The criteria cells are as follows...
    B3, H3, N3
    B8, H8, N8
    B13, H13, N13
    B18, H18, N18

    and so on...
  25. Small VBA code needed for delete with criteria

    Hi all

    I want to delete contents of a sheet based upon some criteria. I am very basic in VBA. I created Select and ClearContent by recording macro. :) But, I am not sure how to add criteria.
    Here...
Results 1 to 25 of 76
Page 1 of 4 1 2 3 4