Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Excel 2010 Expert 2
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   10 years ago

This is the second class in our Excel 2010 Expert Series. It picks up where Expert Level 1 left off. The focus of this course is working with date and time values in Excel. Topics covered include:

- Understanding how Excel stores dates/times
- Date/time arithmetic (adding, subtracting)
- Custom date/time codes and formats
- Most popular date/time functions
- Determining the components of a date/time
- Constructing a date/time from it's components
- Calculating an age or anniversary date
- Determining the work days between two dates
- Creating a time sheet to track hours

Excel 2010 Expert 2 3 19 Upload Images   Link 
Rajiv Dass 
6 years ago
Excel 2010 Expert 2 (3:19), you inputted three "yyy" to get a four digit year for Custom and toward the end (05:24), Custom Date Codes only two options "yy" & "YYYY"?

Reply from Alex Hedley:
Add a Reply
Time 00 56 Upload Images   Link 
Rajiv Dass 
6 years ago
Excel 2010, Expert 2, lesson 3 (00:56), you have input lower case "am/pm" but the output was upper case "AM"?
Add a Reply
Date Differences Upload Images   Link 
6 years ago
i want to calculate difference between two date n time for example:- cell1 30/06/15 cell2 09:50:00 am cell 3 01/07/15 cell4 02:50:00 am. Plz tell me if you can do it.

Reply from Richard Rost:
Add a Reply
VALUE error Upload Images   Link 
Sandra F 
6 years ago
=IF(G93='Daily Cash_Sales_AR Summary'!AC2,'Daily Cash_Sales_AR Summary'!c8:c14,"-")
I get a 'Value' Error with the above;  G93 and AC2 are Dates...Anybody?

Reply from Alex Hedley:
Add a Reply
DATEVALUE Upload Images   Link 
Joe Beniacar 
7 years ago
Hi Richard, thanks a lot for your very helpful videos! Just a quick question: when would it be faster to use DATEVALUE and TIMEVALUE with Format Cells, rather than simply typing in the actual Date to a cell to begin with? Thanks!
Add a Reply
Excel Advanced Upload Images   Link 
Laurie Jones 
8 years ago
Richard, you are by far the best teacher I have ever had in computer classes. Can you tell me when will you have the Excel Advanced courses available in the Theater? Thanks so much.

Reply from Richard Rost:
Add a Reply
VALUE error Upload Images   Link 
8 years ago
Hi Richard,
I tried it with and without the parentheses. I was thinking perhaps it was something behind the scene, so I began from the beginning and got the same result

Reply from Richard Rost:
Add a Reply
VALUE error Upload Images   Link 
Alexandria Hutchinson 
8 years ago
Expert 2 (6)
when I put in =(D2-C2)I get #VALUE it won't give me same as what you have

Reply from Richard Rost:

What values do you have in D2 and C2?

Try it without the parentheses. Just:
Add a Reply
Upload Images   Link 
Patrick Breuer 
8 years ago

Thanks for sharing a great tool to calculate the quarter (5:30), but what if a accounting year begins 1 Oct. Is there anyway to "trick" Windows to show 1 Oct as the first quarter and July - Sept as the 4th quarter? Read More...
Add a Reply
Time Format Upload Images   Link 
Patrick H 
9 years ago
The space between the 8 and am thing makes all the difference, Thanks

Reply from Richard Rost:

It's one of the things I find extremely annoying about Excel. If Excel sees "8am" it should treat it as a time. Read More...
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

6/23/2021Import Data
5/14/2021Quick Queries #4
4/4/2021Text to Columns
3/15/2021VLOOKUP in Access
2/17/2021Old Excel 2003 Outlines
2/17/2021Excel Expert Outlines
2/17/2021Excel Beginner Outlines
2/4/2021Free Beginner Courses
12/26/2020Import New, Changed Records
12/13/2020Duplicates Conditional Formatting

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: excel date time now today year month day hour minute second weekday datedif yearfrac  Page Tag: whatsnew  PermaLink