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 More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Excel 2010 Expert 2
By 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
- 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

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"?

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"?
heri
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.

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?

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!
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.

Alexandria
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

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

What values do you have in D2 and C2?

Try it without the parentheses. Just:
Patrick Breuer
8 years ago
Richard,

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?
Patrick H
9 years ago
The space between the 8 and am thing makes all the difference, Thanks