+ Reply to Thread
Results 1 to 2 of 2

MOD formula for time log and number of fixed breaks

  1. #1
    Registered User
    Join Date
    10-16-2019
    Location
    Illinois
    MS-Off Ver
    2013
    Posts
    4

    MOD formula for time log and number of fixed breaks

    I have a sleep log where will need to put in time go to sleep, number of times up and such. Format will be something like this:

    Time get ready for Bed (will be say 11:30 pm)

    Time lights turned off (something like 11:40 pm)

    How long did it take to fall asleep (will be number of times)

    Did you knowingly wake during the night. (yes or no)

    # of times wake during night (number of times)

    In total how long did these awakings last last (will be fixed time like 15 minutes)

    What time did you wake? (time will be like 6:30 am)

    What time get out of bed? (like 6:35 am)

    How many hours did you sleep last night? (number)

    I am thinking an MOD type formula might work but not certain how to create with all these factors. Any assistance would be appreciated.

    David

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: MOD formula for time log and number of fixed breaks

    You have described the data you will input, but I don't know what question you are trying to answer here. Hours of sleep? What result do you want that you think might involve a MOD function?

    I suggest you attach an Excel file with an example, and show what result you want for that sample of data.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Insert page breaks at fixed number of rows
    By jasminjakson in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-01-2018, 08:24 AM
  2. Replies: 0
    Last Post: 10-05-2018, 11:21 AM
  3. Fixed last page header/footer without the use of section breaks
    By HelpNeed in forum Word Programming / VBA / Macros
    Replies: 24
    Last Post: 08-07-2017, 03:10 AM
  4. [SOLVED] Dividing af formula for elapsed time with a fixed(static) time
    By cbend001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2014, 09:37 PM
  5. Complex query: mean with respect to time rather than fixed number of cells
    By thoabb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2014, 07:30 AM
  6. How to Add New Line Breaks in Comments with VBA if the Max is fixed?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-06-2011, 06:11 AM
  7. Substracting a fixed number of hours to a time
    By PauloCR in forum Excel General
    Replies: 5
    Last Post: 09-19-2006, 09:26 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