+ Reply to Thread
Results 1 to 5 of 5

Charting Medication date and time

  1. #1
    Registered User
    Join Date
    04-15-2015
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    3

    Charting Medication date and time

    I'm not sure if excel is what I need but I'm caring for my father and I need to show him on paper when to take a certain medication. He's very old school and and he's getting real tired of alarms and such. I need to plug in the date and time he takes the medication and then have the program plot out taking it again every 15 hours for however long excel will plot it out.

    So it would start off with 4/15/15 3:08am and when you hit enter it would automatically show 4/16/15 6:08pm 4/17/15 9:08am....ect until it comes to the end of the page.

    Again I'm not sure if excel is what I'm looking for and I just need it on paper for my father and really don't want to put hours in doing the math when I have technology. Thanks

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441

    Re: Charting Medication date and time

    You can use a simply formula to add 15 hours to the start date.

    Rough example attached.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-15-2015
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    3

    Re: Charting Medication date and time

    Ok I'm not confused with what you did, I did the same thing on a piece of note book paper. You added a check box.....
    I want to input the date and time and just hit enter then excel plots out the rest of the dates and times........ does this make sense.?
    It is a printed form of a timer that goes off every 15 hours.....

    Don't get me wrong Andy I'm grateful for your help and effort. I just did what you did on notebook paper so that
    I could see what I wanted and explain it here....sorry

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441

    Re: Charting Medication date and time

    Try sticking a new date/time in the orange cell.

  5. #5
    Registered User
    Join Date
    04-15-2015
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    3

    Re: Charting Medication date and time

    WOW, duh............OMG............Now that's exactly what I wanted. Thank-you so much Andy and on behalf of my father I also thank you. You just won't understand what this will do for him.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Charting Date and Time data to show trends
    By Pdxblues in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-18-2014, 07:21 PM
  2. Replies: 4
    Last Post: 12-01-2012, 09:37 AM
  3. Charting multiple start/finish date/time stamps
    By kerrie92 in forum Excel General
    Replies: 0
    Last Post: 05-17-2010, 01:49 PM
  4. Time and Date Charting
    By JackTheDog in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-24-2009, 04:44 AM
  5. time and date charting
    By changetires in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-09-2006, 11:02 AM

Tags for this Thread

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