Traditional Culture Encyclopedia - Photography and portraiture - Excuse me, in excel, "Today is: 2011April 15[ Friday] now is: 14 hours, 5 minutes and 7 seconds".

Excuse me, in excel, "Today is: 2011April 15[ Friday] now is: 14 hours, 5 minutes and 7 seconds".

The formula of the first layer can be simplified as:

=TEXT(TODAY (), "Today is: yyyymm DD AAAA")&; TEXT(NOW (), "Yes: [dbnum2]h m minutes s seconds")

It's easier if you don't consider Chinese capitalization:

=TEXT(NOW (), "Today is: yyyy, mm, Month, dd, aaaa, now is: h, m, minutes, s")