Hello all,
My now() function is only providing the date as DD/MM/YY. How can I manage to get the current hour also like in this video?
Thank you
My now() function is only providing the date as DD/MM/YY.
This happens, if you (or your template) format(s) cells as date before you enter formula =NOW(). Clear all formatting using CTRL+M before you enter the formula and you’ll get the full time information according to your locale.
→ click right → Format cells → Number → Formatcode: dd/mm/yy HH:MM
Many thanks