[Question] Can you write a conditional statement to sort times based on date.

%3CLINGO-SUB%20id%3D%22lingo-sub-2847469%22%20slang%3D%22en-US%22%3E%5BQuestion%5D%20Can%20you%20write%20a%20conditional%20statement%20to%20sort%20times%20based%20on%20date.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2847469%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20very%20curious%20I'm%20trying%20to%20write%20a%20spreadsheet%20that%20will%20calculate%20lost%20time%20over%20few%20days.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20spreadsheet%20will%20have%20all%20weeks%2C%20using%20a%20given%20date%3A%20e.g.%3C%2FP%3E%3CP%3EA%20vertical%20cell%20will%20have%20a%20information%20from%20dates%2011%2F02%2F2022%2C%2012%2F02%2F2022%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20cell%20of%20total%20time%20lost%2C%20what%20I%20essentially%20want%20it%20to%20do%20is%20filter%20it%20e.g.%20take%20every%20duration%20from%2011%2F02%2F2022%20and%20add%20it%20together%2C%20is%20there%20a%20formula%20I%20could%20use%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2847469%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2847821%22%20slang%3D%22en-US%22%3ERe%3A%20%5BQuestion%5D%20Can%20you%20write%20a%20conditional%20statement%20to%20sort%20times%20based%20on%20date.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2847821%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1185911%22%20target%3D%22_blank%22%3E%40AdrianMachnik%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20of%20this%20writing%2C%20you've%20had%2034%20views%2C%20no%20replies.%20I%20suspect%20that's%20at%20least%20in%20part%20because%20it's%20not%20at%20all%20clear%20what%20you're%20trying%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20say%20you're%20trying%20to%20create%20a%20spreadsheet%3A%20I'm%20going%20to%20presume%20that%20means%20you've%20got%20one%20in%20the%20works.%20Why%20don't%20you%20attach%20it%2C%20whatever%20state%20it's%20in.%20That%20will%20go%20a%20long%20way%20toward%20helping%20us%20visualize%20what%20your%20words%20are%20attempting%20to%20describe.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%2C%20in%20addition%2C%20if%20you%20could%20give%20an%20example%20or%20two%20of%20what%20the%20data%20would%20be%20and%20what%20you%20expect%20the%20result%20of%20the%20formula%20to%20be.%20Formulas%20themselves%20are%20often%20pretty%20easy%2C%20but%20you%20first%20need%20to%20know%20in%20words%20(or%20examples)%20what%20it%20is%20that%20you%20want%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20if%20you%20want%20to%20try%20to%20figure%20it%20out%20yourself%2C%20here's%20a%20link%20to%20a%20website%2C%20specifically%20to%20a%20page%20with%20some%20instructions%20on%20%22date%20math%22%20in%20Excel.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fformula%2Fget-work-hours-between-dates-custom-schedule%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fformula%2Fget-work-hours-between-dates-custom-schedule%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20if%20you%20want%20help%20here%2C%20please%20give%20us%20a%20hand%20in%20helping%20you%20by%20doing%20the%20things%20I%20describe%20above.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello everyone,

 

I am very curious I'm trying to write a spreadsheet that will calculate lost time over few days. 

 

The spreadsheet will have all weeks, using a given date: e.g.

A vertical cell will have a information from dates 11/02/2022, 12/02/2022 etc.

 

I have a cell of total time lost, what I essentially want it to do is filter it e.g. take every duration from 11/02/2022 and add it together, is there a formula I could use?

 

Thank you in advance.

 

1 Reply

@AdrianMachnik 

 

As of this writing, you've had 34 views, no replies. I suspect that's at least in part because it's not at all clear what you're trying to do.

 

You say you're trying to create a spreadsheet: I'm going to presume that means you've got one in the works. Why don't you attach it, whatever state it's in. That will go a long way toward helping us visualize what your words are attempting to describe.

 

Then, in addition, if you could give an example or two of what the data would be and what you expect the result of the formula to be. Formulas themselves are often pretty easy, but you first need to know in words (or examples) what it is that you want to do.

 

Now, if you want to try to figure it out yourself, here's a link to a website, specifically to a page with some instructions on "date math" in Excel. https://exceljet.net/formula/get-work-hours-between-dates-custom-schedule

 

But if you want help here, please give us a hand in helping you by doing the things I describe above.