Содержание
Course Overview 1m 57s Course Overview 1m 57sReferencing Current Date and Time 7m 14s Course and Module Introduction 1m 40s NOW Function 1m 59s TODAY Function 55s Demo: Implementing the NOW and TODAY Functions 2m 39sSerializing Dates and Times in Excel 8m 47s Module Introduction 37s Date and Time Storage in Excel 4m 18s DATE and TIME Functions 3m 52sCalculating Differences Between Dates and Times 19m 51s Module Introduction 1m 12s Comparing Given Date with Current Date 3m 35s Calculating Differences in Timestamps 5m 41s Calculating Differences in Dates - DATEVALUE 3m 51s Calculating Differences in Dates - DAYS, DATEDIF and DAYS360 5m 30sFinding the Day, Month, Weekday, or Year of a Date 8m 5s Module Introduction 50s DAY and WEEKDAY Functions 5m 21s MONTH and YEAR Functions 1m 52sFinding the Hour, Minute, or Second of a Time 7m 25s Module Introduction 40s HOUR Function 1m 30s MINUTE and SECOND Functions 1m 11s Demo: Implementing the HOUR, MINUTE, and SECOND Function in Excel 2m 4s Course Summary and Feedback 1m 58s