Difference between dates with now() AND only filter collumn results with data

[fleyd]

Hi everyone,

I have 2 problems that i would need help with:

1 - I have a start date and time that i want to subtract to a end date and time. It works if i place the start date and time manually, but since i want to use start date with today function and start time with now function, it doesnt work this way...

2- I have a sheet with many prices (horizontal) and clients (vertical), i know, using excel online and office 365, use filter function, but the problem is that i have more than 2 collumns and i would like a way, after choosing the client, only appears the collumns with data and ignore the others.

I have an example file so you can see better what i am trying to explain.

Can someone help please?

[LouisTh]

Hi,
Here's the formula i used for the dates: =CONCATENATE((B4-B8)," days ",TEXT((C4-C8),"HH:MM")," hours") It can probably be more efficient or pretty but it works.
Not sure i can help with the second request without a bunch of IF statements but again i'm sure it's doable.

Hope this helps
LouisT

[Roel Jongman]

the function NOW() gives not only time but also the date. if you change cell C4 to

Please Login or Register  to view this content.

will give you only the time.

but you could also change the formula to only substract C4 and not B4 also
so then keep current formula of C4 and change -(B4+C4) into -C4
in celll C10

[joeu2004]

See my response to the same question at https://www.mrexcel.com/board/thread...h-data.1121396 .

[fleyd]

Many thanks to all of you for the help, regarding the time question.

Can someone help please regarding the filter question please?

Regards.