Time and Date in Excel
Tutorials focused on Excel date calculations, times, durations, timestamps, and common formatting edge cases.
26 articles
How to Convert Text to Time in Excel (and Fix TIMEVALUE Errors)
Convert imported text times with TIMEVALUE, check numeric timestamps, remove ordinary spaces, and handle valid HHMM entries such as 930 and 0030....
How to Add or Subtract Months from a Date in Excel
Use EDATE to add or subtract months from a date, handle January 31 and leap years, and keep renewal dates tied to the original start date....
How to Insert a Timestamp in Excel: Static, Dynamic, and Automatic Methods
Insert a fixed timestamp with Excel shortcuts, show the current time with NOW, or record data entry with an iterative formula or VBA....
How to Calculate Hours Between Two Dates and Times in Excel
Calculate elapsed hours between Excel dates and times, display totals over 24 hours, convert to decimal hours, and handle overnight shifts....
Excel Fractional Part: Extracting Integers and Fractions in Excel
Sometimes you need to extract the integer or decimal part of a number. Sometimes the fractional part. Check this guide on Excel fractional part....
Extract Time from datetime with the MOD Function in Excel
Use the MOD function in Excel to extract a Time value from a Date-Time number. Change the cell formatting to get the time format of your choosing....
How to Extract Time from DateTime values in Excel
Discover how to skillfully extract time from datetime values in Excel. Learn simple techniques to manage and analyze your data efficiently in this step-by-step guide....
Extract Date from DateTime Number in Excel
You can extract the Date value from a Date-Time number using the INT function in Excel. Then change the cell formatting to a Date format....
Pay Periods and Funky PivotTable Controls
Use a PivotTable to find how many months in a year have an extra pay period. Excel 2011 PivotTable controls are funky looking, comparatively speaking....
International Short Date Formatting for the TEXT Function
A quick method to automatically give the TEXT function a short date format that matches the computers region settings by using some VBA code in Excel....
Regional Date Format in Excel for Mac and Windows
Discover how to set and use regional date format in Excel effectively. Enhance your spreadsheets with this essential Microsoft Excel tip....
How to Quickly Convert 1904 Dates to the 1900 Date System in Excel
Learn how to convert 1904 date system values to the 1900 date system in Excel. This guide covers methods for accurate date and date systems management in Excel....
A Woopra Chat About Excel
Convert minutes and seconds to a value of minutes followed by the text MIN and formatted correctly with no decimal places by using the TEXT function....
Let Excel Convert Hours Between Two Dates and Times
Let Excel Convert Hours Between Two Dates and Times by subtracting one time/date from another the use the custom time format [h]:mm or [h]:mm:ss....
What Day of the Year is It?
The embedded spreadsheet will take a date value and return the Day of Year with a formula that uses the DATE Function....
Use the DATEDIF Function to Quickly Calculate Date Difference in Excel
Use the DATEDIF Function in Excel to find the number of Years, Months and Days between two dates. Only documented in Excel 2000 but in later versions....
Calculate the Xth Weekday of Any Month in Excel
A simple formula to calculate the Xth Day of any month using four inputs: Year, Month, Week, and Day. Data validation with custom formatting required....
Converting Pace in Minutes per Mile to MPH and Back Again in Excel
I'm converting Pace to MPH and then reversing the process, converting MPH to Pace, to create a conversion chart....
Convert Decimal Hours to Time in Excel — Including Totals Over 24 Hours
Divide decimal hours by 24 and format as [h]:mm to show hours and minutes, including totals over 24 hours. Reverse the conversion and find total minutes....
The WEEKDAY Function in Excel
Excel 2010 has new function arguments for the WEEKDAY Function. It returns an integer value based upon the day of the week....
How Excel Stores and Calculates Dates and Times
See how Excel stores dates and times as serial numbers, combine a date and time, and calculate a simple elapsed duration....
How to Convert Text to a Date in Excel
Convert text to dates in Excel with DATEVALUE or a fixed-layout DATE formula, then format the numeric result....
The VALUE Function in Excel – Converting Text Dates
Converting text string Dates to numeric serial number values using the Excel VALUE Function and with alternate methods: addition, multiplication, division, and double negation....
Extract a Date from Text in Excel
Extract a Date from Text values by using a formula in Excel....
Create a Date Schedule in Excel: Daily, Monthly, and Weekdays
Create daily, weekly, and weekday date lists with Fill Series, then build a monthly schedule that updates from one fixed starting date....
Microsoft Excel Date Systems for Windows and Mac
Excel date systems for Windows and Mac are drastically different and can be confusing. Sharing Excel files between Windows and Mac computers can be confusing because of the two different date systems....
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us