On Mac Excel, insert a function in cell B2 to display the current date and time, and then format as a Long Date

Question

I am using this formula**
=NOW()**

but, This formula is only showing the date and not the time

=NOW(), tried this, please can somebody help me with this, i am trying to find from a long time, thank you for help in advance

Answer 1

I assume these would work on Mac as well as PC: =TEXT(NOW(),"dddd, mmmm dd, yyyy h:mm") or =TEXT(NOW(),"dddd, mmmm dd, yyyy h:mm am/pm")