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?
Excel Example

 

[joeu2004]

Use the Evaluate Formula operation to step through the calculation.

The formulas that return #VALUE include references to column A, which is empty. Thus, for example, DATEVALUE($A$8) is evaluated as DATEVALUE(0), which returns #VALUE because 0 is not a value date serial number. (Date serial numbers begin with 1.)

Unrelated observation.... The formula =NOW() in C4 should be =MOD(NOW(),1) at the very least, and =--TEXT(NOW(),"h:m") or =--TEXT(NOW(),"h:m:s") is better.

Otherwise, NOW() includes today's date. That is, it is not just time of day, even though that is all that is displayed because of the cell format.

The latter is better because MOD(NOW(),1) is not the binary representation as the time of day as a constant. So it might cause anomalies in some formulas; for example, MATCH and VLOOKUP functions

That might explain the comment in B1 and G1. I cannot be sure because I did not get past the #VALUE errors.