# Excel 2013: Master Date Time Calculations in 1 hour

Learn all there is about Date and Time calculations in Excel in just under 1 hour.
0.0 (0 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
0 students enrolled
\$20
• Lectures 5
• Contents Video: 1 hour
• Skill Level All Levels
• Languages English
30 day money back guarantee!
Available on iOS and Android
Certificate of Completion
Wishlisted Wishlist

### Discover

Find online courses made by experts from around the world.

### Learn

Take your courses with you and learn anywhere, anytime.

### Master

Learn and practice real-world skills and achieve your goals.

Published 2/2015 English

### Course Description

Ever had trouble with Dates and Times in Excel? Ever subtracted dates or times and ended up with gibberish? Ever wanted to learn how to calculate Date and/or Time differences once and for all? Well then....this course is for you!

After this course you'll never need to consult any other help file or tutorial. I'll give you the Big Easy on Date Time calculations. Whether its Dates, Times or DateTime Values, you'll feel confident in using Excel's built-in functions to manipulate them. And where Excel does not have "good" functions to help you, I'll teach you tricks simple-yet-powerful to get your desired result.

I assure you, this is your one stop junction for acquiring Mastery in Date and Time data types in Excel 2013.

### What are the requirements?

• Students only need to have a very basic understanding of Excel

### What am I going to get from this course?

• Understand Date and Time Logic in Excel
• Effectively use Excel's built-in DateTime Functions
• Calculate Date Time Differences
• Manipulate DateTime Values using the INT Function
• Master the Date and Time Calculations in Excel

### What is the target audience?

• Anybody who has ever had difficulties in understanding Date and Time values in Excel

### What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

# Curriculum

Section 1: Date Time Basics
Date Time: Syntax and Format
12:29
Date Time: Understanding the Logic Behind
05:44
Date Time: Useful Functions
17:32
Section 2: Calculating Date Time Differences
How to Calculate Date Time Differences
18:00
Using Int Function to Calculate Differences
04:28