Join Dennis Taylor for an in-depth discussion in this video DATEVALUE and TIMEVALUE: Converting text entries into dates and times, part of Working with Dates and Times in Excel 2007.
When you download data from other sources, sometimes you end up with date and…time information that's in text format.…And although it appears sometimes that you can perform occasional math on these…functions by adding numbers to them, you can't always format the information…properly, and you need to convert it into dates and time so you can properly use them in Excel.…We are talking about two different functions related, very similar name,…DateValue and TimeValue.…Let's take a look at how this might work.…
The data in column A is in text form.…There are four variations on it.…These are text entries.…And we can't do as much with them as we might want to in Excel, in terms of…manipulating them and using them in a mathematical way.…So using column B here, let's put in =datevalue, simply referring to…this cell over here.…And we are likely to end up with a date number.…I might do this for the rest of these as well.…And you may recall there are a couple of quick ways to quickly change this into…a visible date; Ctrl+Shift+# is one of them.…
- Understanding how Excel records and stores dates and times
- Looking at standard date/time entry options and acceptable alternatives
- Using the TODAY and NOW functions
- Customizing date formats
- Exploring keyboard shortcuts
- Formatting time for hours over 24
- Calculating differences across dates and times
- Rounding calculations
- Working with holidays
- Validating with dates
- Converting formatted dates to usable data
Skill Level Intermediate
Excel 2007: Introduction to Formulas and Functionswith Curt Frye2h 26m Intermediate
Creating Business Budgets in Excel 2007with Curt Frye1h 3m Intermediate
1. Excel's Date/Time System
2. Creating Date/Time Entries
3. Date/Time Formatting
4. Excel's Date/Time Functions
5. Calculating with Dates and Times
6. Using Dates and Times with Excel Commands
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.