Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds; generated 53 minute(s) ago.

  1. Replies
    19
    Views
    437

    Re: Display time in hours?

    :laugh:
  2. Replies
    19
    Views
    437

    Re: Display time in hours?

    ;) Unless I'm having one, all that does is replace the ":" with a ".". I want "7:45" to display as "7.75". That is, 7 hours and 45 minutes is to display as 7.75 hours. No?
  3. Replies
    19
    Views
    437

    Re: Display time in hours?

    Wowie Zowie!!!

    That is so far over my head that I can't even imagine how long it would take for me to comprehend what it is doing. :confused:

    I give you the VBA Wizard award for this one. :bow:
  4. Replies
    19
    Views
    437

    Re: Display time in hours?

    That's a very good article. Thanks.
  5. Replies
    19
    Views
    437

    Re: Display time in hours?

    Interesting. Is this documented somewhere? I couldn't find it.

    I ran a few simple tests.


    <tbody>
    R/C
    C
    D
    E
  6. Replies
    19
    Views
    437

    Re: Display time in hours?

    OK, that gets the display you show, but can you explain what the format codes are actually doing?

    I thought the "?" was a digit placeholder, like "0" but for spaces.

    What do the "/" and the...
  7. Replies
    19
    Views
    437

    Re: Display time in hours?

    That's interesting. When I try that, the cell shows 775/2400. What does the "/" + Ctrl-J + "2400" do?
  8. Replies
    19
    Views
    437

    Re: Display time in hours?

    I was hoping that the cell could continue to contain the value read off the stopwatch (7:45), but display the time in hours (7.75). I was thinking of the way 0.6666666666667 was keep that value, but...
  9. Replies
    19
    Views
    437

    Re: Display time in hours?

    That macro will change the value in the cell, right?

    I was hoping for a way to leave the value as is (in days), but display it in hours. I guess I'll use a separate cell for the value.

    Thanks
  10. Replies
    19
    Views
    437

    Display time in hours?

    Is there a way that I can enter a time value from a stopwatch as hh:ss and have it displayed as hours (hh.hh)?

    For example, I'd like to enter "7:45" in a cell and have "7.75" displayed in that...
  11. Re: Best way to skip 1st & last cell in range in UDF?

    The processing is nothing simple like that.


    Perhaps, but often necessary.


    I never said anything about either of those objectives.
  12. Re: Best way to skip 1st & last cell in range in UDF?

    Perfect. And I can get the value in each cell as text using:


    Ratings(i).Text


    Thank you
  13. Re: Best way to skip 1st & last cell in range in UDF?

    It's doing all of that and more. But what difference does that make? I want the UDF to step through each of the cells in the range skipping the first one and the last one?
  14. Best way to skip 1st & last cell in range in UDF?

    I have a little UDF that does some tallies on a column of cells (B2:B5).


    <tbody>
    R/C
    A
    B


    1
  15. Re: How to insert multiple rows from one sheet into another

    Thank you. That works perfectly.

    I would update your instructions a bit to this:

    To copy or move a range of rows or columns and insert them between two existing rows or columns, use the Insert...
  16. How to insert multiple rows from one sheet into another

    Is there a way that I can insert a range of rows (18:35) from Sheet1 in between rows 17 & 18 in sheet2?

    Everything I have tried ends up replacing at least one row in the target sheet. I suppose I...
  17. Re: UDF stops running if I hot-key to another task

    Ooopppsss. I was wrong. The UDF does not stop running. It's something to do with the InputBox. If I hot-key just as it is being displayed, Excel goes into a funny mode where the Icon in the Taskbar...
  18. UDF stops running if I hot-key to another task

    I have a UDF that does some iterative calculations. It can take anywhere from about 2 to 8-10 seconds to complete its work. The data, which I enter into an InputBox, comes from another application....
  19. Re: how to use a named range in the Offset function

    Perfect. Thank you very much
  20. Re: how to use a named range in the Offset function

    That's an interesting solution. I hadn't thought of that. It would make this formula work, but would cause all my others to fail.


    Yes, but as I already said, this misses the main point. I am...
  21. Re: how to use a named range in the Offset function

    Of course.


    Not at all.

    I assigned the name "Price" to column D and "Shares" to column E. The formulas in F6:F8 are all "=Price*Shares". That formula is able to use the values in the named...
  22. Re: how to use a named range in the Offset function

    I named the range (column) because I want to use named addressing, not literal addressing. I want to use the name "Balance" in some formula that will calculate the difference between the balance in...
  23. how to use a named range in the Offset function

    In the table below, I have assigned the name "Balance" to column F. I would like to replace "F6" in I6 with the named range, "Balance", but the offset function doesn't like it.


    <tbody>
    R/C

    C...
  24. Re: Is there any way to emulate non-numeric subscripts in VBA?

    The dictionary variables are working great. Thanks for that tip. Here's a section of that code.


    Function TallyResults(Results As Range, Player As String, GSM As String, WL As String)

    Dim rRow...
  25. Re: Is there any way to emulate non-numeric subscripts in VBA?

    That fixed it. Thanks. I misunderstood that part of the tutorial.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4