Excel VBA Basics #24 DateDiff in VBA - Difference in Seconds, Hours, Weekdays, Quarters, Months, Etc
ExcelVbaIsFun
0:00 / 0:00
Excel VBA Basics #24 DateDiff in VBA - Difference in Seconds, Hours, Weekdays, Quarters, Months, Etc
31 743 просмотра · 13 лет назад
ExcelVbaIsFun
97 тыс. подписчиков
31 743 просмотра · 13 лет назад
📊 Free Workbooks: https://www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: https://www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)
Find the difference between two dates/times. Find out how many hours, seconds, quarters, months, years, weekdays, weeks, days, whatever!! You can calculate using similar descriptions as with DateAdd:
s Seconds
n Minutes
h Hours
d Days
w Weekdays
ww Weeks
m Months
q Quarters
y Days of the year
yyyy Years
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: https://www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: https://www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: https://www.excelvbaisfun.com/contact/