An Excel Tutorial for Combining the TEXT and the NOW Functions.

Posted on May 29, 2008 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - An Excel Tutorial for Combining the TEXT and the NOW Functions.

I hope you enjoyed yesterday’s Outlook Tutorial but for now you can forget about it because where picking up where we left off with our Microsoft Excel Tutorial week.

 

I explained in the Excel Tutorial for using the TEXT and the TODAY functions that Microsoft Excel saves the dates in his software as a sequential number. Excel needs to do this otherwise the program can’t use that value to calculate with. I explained that sequential numbering started on January 1, 1900. And that January 1, 1900 had the value 1 and May 27, 2008 had the value 39594. This was because of the 39594 days that came after January 1, 1900 till May 27, 2008. Excel uses this same setup for calculating the time. If the number to right of the decimal point is .5, then the value stands for 12:00 noon. If the value would be 1.75 then the real date and time would be January 1, 1900 and 18:00 hours.

 

I want to show you in today’s Tutorial how to combine the TEXT and the NOW function in one formula.

 

  • You’ll need to start with typing in cell B1 =NOW()

 

Excel-formula-tutorial-pic1

 

  • Type the formula =B1+0.25 in cell B2. (0.25 stands for 6 hours, ¼ of a day)

 

Excel-formula-tutorial-pic2

 

  • Now select cell A3 and type in the following formula ="The project meeting starts at "&TEXT(B1;"HH:MM")&" and ends at "&TEXT(B2;"HH:MM").

 

Excel-formula-tutorial-pic3

 

  • And when you have clicked on Enter you’re spreadsheet should look like this.

 

Excel-formula-tutorial-pic4

 

I hope you liked this Excel Tutorial and that this sequential numbers done by MS Excel is understandable. I don’t know if I explained it correctly, if not please feel free to drop a comment. I’ll talk to you all on Monday with another Excel Tutorial. I’ll show you how to combine different values into one date column. See you tomorrow!!

 

 

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

Leave a Reply