Time and Date in Excel
Tutorials focused on Excel date calculations, times, durations, timestamps, and common formatting edge cases.
24 articles
4 Methods to Insert a Timestamp in Excel Cell
Explore easy methods to insert timestamp in Excel. Learn shortcuts, formulas, and VBA for effective data tracking in our concise guide....
How to Calculate Hours Between Two Dates and Times in Excel
Learn how to calculate hours between two dates and times in Excel using simple formulas for elapsed time, decimal hours, overnight shifts, and workdays....
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....
How to Convert Decimal Hours to Time in Excel
Master the art of converting decimal hours to time format in Excel. Easily track minutes and hours In work and log books, events and when analyzing time data....
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....
Date and Time Calculation in Excel
Date and Time are the components of a serial number value, and are represented by an integer and decimal, respectively....
Convert a Text String Date to Date Serial Number
One formula to convert a text string date to a date serial number using double negation, MID Function, Ampersand Operator, and the RIGHT Function....
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....
Generate a List of Dates in Excel
Generate a date series in Excel quickly with the Edit, Fill, Series pop-up box....
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