Jump to content

Expert Skills Excel 2016 Session3-14 Common Time Functions

2 replies to this topic

#1 Guest_Paul Weekley_*

Guest_Paul Weekley_*
  • Guests

Posted 27 February 2018 - 08:36 PM

I didn't see this problem entered before so if this is a duplicate question I apologize.


Lesson 3-14 Understand common time functions and convert date serial numbers to decimal values.


Page 131

    Step 1    Type current date and time into cell A15

    Step 2    Click on cell B15

    Step 3    Type =NOW


Whenever I clicked in B15 and entered =NOW, I kept getting a #NAME error. No matter what cell I clicked in I got that error.

The only way I could get it work was to enter +NOW()

Did I miss something?

#2 Mike


    Advanced Member

  • Administrators
  • 188 posts

Posted 28 February 2018 - 02:17 PM

Dear Paul


I'm guessing that the problem is that instead of typing NOW you have typed NOW + <Enter Key>


Here are the five steps listed in the book:


1. Type Current Date and Time into cell A15.
2. Click on cell B15.
3. Type =NOW
4. Press the <Tab> key twice.
5. If necessary, widen columns A and B so that they are wide enough to see all of their contents.
If you follow this carefully (and do not press the <Enter> key after typing NOW) you should find that everything works perfectly.
If the above information does not enable you to solve the problem let me know (along with the version of Excel 2016 you are using).
Best Regards
Mike Smart

Mike Smart is the author of ten world best-selling Excel books. The books are available in printed form for for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Mike has also recorded over 850 video lessons (that you can watch online) for Excel 2007, Excel 2010 and Excel 2013.
Mike Smart is also part of the team that answers questions posted on the ExcelCentral.com forums.

#3 TallPaul



  • Members
  • Pip
  • 9 posts

Posted 01 March 2018 - 07:38 PM

That solved the problem, thanks!!!

Reply to this topic


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users