Measuring how much time has passed between two times in Google Sheets may seem easy. But when those times are on different days, it can be tricky. Let’s take a look.
TIMEDIF - https://bit.ly/timedif
DATEDIF Function - https://sheetshelp.com/datedif/
Find the Time Difference (this video's subject) - https://sheetshelp.com/difference-bet...
Timestamps:
0:00 Intro
0:13 Basic Walkthrough
0:47 Two Times - Close Together
1:32 Formatting
3:08 Two Times - Farther Apart (Years, Months, etc.)
3:53 DATEDIF Function
5:34 TIMEDIF Add-On
#googlesheets #spreadsheet #timedif