Published On Jan 23, 2024
In this video we'll take a look at how to do calculations in excel using both date and time. We'll start by learning how excel stores dates and time, then move on to some calculations that will make your life easier.
0:00 Intro
0:05 How dates and time are stored in excel *IMPORTANT Don't skip*
4:16 Add days to a date
4:52 Add months to a date
5:24 Display dates a month, or day
6:34 Add years to a date | Two methods
8:54 Calculate the differences between two dates
10:27 Time calculations intro
10:58 Calculate hours worked
11:52 Calculate hours worked minus lunch
13:04 Round time up to nearest 15 minutes
14:05 Round time to the closest 15 minutes
14:55 Various ways to insert current date/ time to your file
š *FREE RESOURCES*
Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31...
Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...
ā ** BUY ME A COFFEE? **
https://www.buymeacoffee.com/professo...