Results 1 to 4 of 4

Filling in tentative times in a cell.

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2018
    Location
    phx az
    MS-Off Ver
    2016 (office 365 E3 Business)
    Posts
    5

    Filling in tentative times in a cell.

    I'm trying to make it easier for my mother to fill in a spreadsheet i made and have it stored on my OneDrive folder. This way I can check and make sure she's taking her meds as needed just by glancing.

    sometimes she doesn't do well with times. One med she takes when she gets up, then another just before bedtime. But she also has some that are based strictly on 8 spreads
    What I did was create a name set with times that she can pick from a dropdown when she takes them. But what I want to do is be able to highlight the next cell with the time she is taking her meds, +8 hours, just greyed out. Like a form with a default value that disappears when they select the cell to enter the real time

    I have trouble with this 1. because it's a time add, and I haven't quite figured it out, and 2. I'm not that familiar with Excel.

    Is this a simple task?
    Last edited by mindz; 11-24-2021 at 12:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Accept/ Decline/ Tentative outlook meeting request via excel sheet
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2019, 01:42 PM
  2. [SOLVED] Filling In Data Based On Half-Hour Times
    By windme in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-28-2019, 06:23 PM
  3. Filling cells down with date and times
    By maw1503 in forum Office 365
    Replies: 1
    Last Post: 10-10-2018, 10:31 AM
  4. Replies: 2
    Last Post: 06-23-2017, 02:47 PM
  5. Replies: 6
    Last Post: 01-20-2014, 01:10 AM
  6. [SOLVED] Auto filling a list with dates and times
    By john dalton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2013, 05:58 AM
  7. [SOLVED] Filling in a number x, y times in y cells
    By Damien in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-18-2006, 09:55 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1