+ Reply to Thread
Results 1 to 16 of 16

Adding time to a date function

Hybrid View

Writingformulas Adding time to a date function 02-01-2023, 01:10 PM
MrShorty Re: Adding time to a date... 02-01-2023, 02:05 PM
Writingformulas Re: Adding time to a date... 02-17-2023, 03:01 PM
MrShorty Re: Adding time to a date... 02-17-2023, 04:43 PM
Writingformulas Re: Adding time to a date... 02-17-2023, 06:48 PM
MrShorty Re: Adding time to a date... 02-17-2023, 07:22 PM
Glenn Kennedy Re: Adding time to a date... 02-17-2023, 10:30 PM
Writingformulas Re: Adding time to a date... 02-18-2023, 11:47 AM
Glenn Kennedy Re: Adding time to a date... 02-18-2023, 08:53 PM
Writingformulas Re: Adding time to a date... 02-18-2023, 08:57 PM
Glenn Kennedy Re: Adding time to a date... 02-18-2023, 09:07 PM
Writingformulas Re: Adding time to a date... 02-19-2023, 08:05 AM
Glenn Kennedy Re: Adding time to a date... 02-19-2023, 08:08 AM
Writingformulas Re: Adding time to a date... 02-19-2023, 10:11 AM
Writingformulas Re: Adding time to a date... 02-19-2023, 08:13 AM
Glenn Kennedy Re: Adding time to a date... 02-19-2023, 10:29 PM
  1. #1
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Adding time to a date function

    Try:

    =LET(A,C7:F1000,B,FILTER(A,INDEX(A,,3)<>0),C,INDEX(B,,1)+INDEX(B,,2),VSTACK(C6:F6,FILTER(B,(C>=N17)*(C<=O17))))

    Refer to the file. I may have added some rows/columns...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  2. #2
    Forum Contributor
    Join Date
    01-07-2023
    Location
    USA
    MS-Off Ver
    MS 365
    Posts
    141

    Re: Adding time to a date function

    That is great , but to go further, I should have mentioned the drop down and the data validation

    Your knowledge is greatly appreciated See attached
    Attached Files Attached Files

+ 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. [SOLVED] sumproduct adding date to time range only works for same date
    By mlan in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-04-2021, 12:44 PM
  2. [SOLVED] Adding business days and time to a specific date and time
    By amitmodi_mrt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2019, 03:32 AM
  3. adding date and time and subtracting date-time2 from date-time1
    By tinkerbelle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-22-2018, 10:05 AM
  4. Adding time (more than 24 hours) to date time stamp
    By sidapt in forum Excel General
    Replies: 6
    Last Post: 01-06-2014, 04:08 AM
  5. Adding elapsed time to date/time format over 24h
    By KimSenger in forum Excel General
    Replies: 1
    Last Post: 04-02-2013, 06:28 AM
  6. Adding Time to a Date & Time (using workdays only)
    By Buks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2009, 10:31 AM
  7. Adding time to date-time formatted cell
    By tawtrey(remove this )@pacificfoods.com in forum Excel General
    Replies: 4
    Last Post: 08-12-2005, 06:05 PM

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