Results 1 to 15 of 15
  1. #1
    Star Lounger
    Join Date
    Jun 2015
    Posts
    59
    Thanks
    13
    Thanked 2 Times in 2 Posts

    spreadsheet with minutes

    Trying to make spreadsheet with 1440 minutes can anyone say which letter it is so I stop at it with doing it one by one please

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,641
    Thanks
    115
    Thanked 652 Times in 594 Posts
    Welcome to the forum. Not sure if this is what you are looking for but starting with column A, 1440 would be column BCJ.

    HTH,
    Maud

  3. The Following User Says Thank You to Maudibe For This Useful Post:

    mar27 (2015-06-14)

  4. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Mar27,

    Welcome to the Lounge as a new poster!

    The method to find the value Maud provided is to open the VBE (Alt+F11)
    Open the Immediate Window (Ctrl+G)
    Type: activecell.Offset(0,1439).Select
    Hit enter and you'll see cell BCJ is selected.

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. The Following User Says Thank You to RetiredGeek For This Useful Post:

    mar27 (2015-06-14)

  6. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,641
    Thanks
    115
    Thanked 652 Times in 594 Posts
    I just used Cells(1, 1440).Select and looked at which column was highlighted. Same idea.

  7. The Following User Says Thank You to Maudibe For This Useful Post:

    mar27 (2015-06-14)

  8. #5
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts
    Quote Originally Posted by RetiredGeek View Post
    Mar27,

    Welcome to the Lounge as a new poster!

    The method to find the value Maud provided is to open the VBE (Alt+F11)
    Open the Immediate Window (Ctrl+G)
    Type: activecell.Offset(0,1439).Select
    Hit enter and you'll see cell BCJ is selected.

    HTH
    Quote Originally Posted by Maudibe View Post
    I just used Cells(1, 1440).Select and looked at which column was highlighted. Same idea.
    Sneaky non-VBA method:

    Change Excel options to R1C1 addressing
    F5 (Goto) to cell R1C1440
    Change Excel back to A1 addressing
    See which column you're in

  9. #6
    Star Lounger
    Join Date
    Jun 2015
    Posts
    59
    Thanks
    13
    Thanked 2 Times in 2 Posts
    Thanks for that will try it shortly

  10. #7
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,641
    Thanks
    115
    Thanked 652 Times in 594 Posts
    Jeremy,

    Without even changing the options you can just enter r1c1440 in the name box (left top corner). Thanks for jogging my memory on that one.

  11. #8
    Star Lounger
    Join Date
    Jun 2015
    Posts
    59
    Thanks
    13
    Thanked 2 Times in 2 Posts
    hi there yesterday I asked for help which I appreciated which I done, the basic is easy trying formal well over my head a friend gave me a starter but trying to either add detail or change it am totally lost

  12. #9
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,203
    Thanks
    49
    Thanked 989 Times in 919 Posts
    We need more information about what you are trying to do in Excel. Please describe it in as much detail as you can.

    cheers, Paul

  13. #10
    Star Lounger
    Join Date
    Jun 2015
    Posts
    59
    Thanks
    13
    Thanked 2 Times in 2 Posts
    Hi, trying to make a sleep tracker, using minute ie either 24 hr or the one I started was 20:00 10:10 a mate tried to help me with one he found but when I try to either add time I counld not get it to work or either edit the two for what I need, without showing I think it will be hard unless you can see, what I am trying to use in minutes then mark under minutes with letter a/s ie awake, sleep then to make total at the end with total awake, sleep and percentage

  14. #11
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts
    Quote Originally Posted by Maudibe View Post
    Jeremy,

    Without even changing the options you can just enter r1c1440 in the name box (left top corner). Thanks for jogging my memory on that one.
    Brilliant!

    Added to my list of Excel tricks

  15. #12
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Mar27,

    I see several problems with using Excel for this level of tracking detail.
    The act of recording times will help to keep you awake.
    How will you know exactly when you fell asleep?

    I think you'd be better off with a device like a Fit-Bit that will track your wake/sleep automatically. Or if money is no object you can get the top of the line Sleep Number bed which has a tracking feature built in to help you set the proper number. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  16. #13
    Star Lounger
    Join Date
    Jun 2015
    Posts
    59
    Thanks
    13
    Thanked 2 Times in 2 Posts
    Hi retiredgeek I have a fit bit but you cannot export the sleep date probably that why i want to make my own but the one I started and the two I got to work off I am baffled

  17. #14
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi

    ..maybe you'll need an Excel clock.
    You can watch this while you are not sleeping!

    zeddy
    Attached Files Attached Files

  18. #15
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,203
    Thanks
    49
    Thanked 989 Times in 919 Posts
    You could just enter the times for each day and do a total at the end. Entering the time is easy if you use 24 hour notation and the colon as the hour minute separator. e.g.
    21/5/2105 00:14 00:54 02:33 03:26 05:47 22:44
    22/5/2015 03:21 04:02 07:58 08:56 13:01 13:39 23:22

    cheers, Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •