How much time will it take to learn piano for playing songs (songs like below)?

It depends. Even to learn to read music, understand basic key changes, bass and treble clef, chord formation, bridges, etc. requires some lessons and daily diligence (read: practice).

All the songs you listed will require the same skills. Do you have a good ear? That helps.

If you want to play a Beethoven concerto with 110 piece orchestra, that will take a little longer.

The ancient joke: How do you get to Carnegie Hall? Practice, practice, practice.

I took lessons for 14 years. My fingers are rusty, but I can read any piece of sheet music put in front of me. But that is manual dexterity and not musical talent.

…with lessons on youtube, some learn overnight…

Learn what?

Ya, probably, unless you put tons of work into it or find some special instructor that will teach you in a week! It would take several hours of practice every day if you wanted to learn that quickly; I’ve been playing for five years and I’d still have to devote a month’s time of heavy practice aside from school to learn one of those if it was an intermediate version of the actual song.

the pianoforte is a very user friendly musical instrument :)

It is, but still -24 hours? It takes longer than that to learn to play the C scale, with both hands.

Someone can teach you all the tennis strokes in one lesson, but I doubt that will get you to Wimbleton without a few weeks’ practice.

It depends on what you want to achieve.

If you want to play these songs by rote learning, it won’t take you long at all.

If you want to understand the instrument and the theory behind it, want to work things out for yourself instead of just being shown, want to understand scales, modes, time signatures, get a feel for the music, want to be able to play songs by ear… i.e. if you want to truly get to know the piano and thus get the most out of it, then this process will take longer.

Obviously, having a natural ear for music will help tremendously with whatever it is you want to achieve.