Excel Date & Time Formulas Tips - All Tips (76 tips)
- Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel
- Convert time to a serial value in Microsoft Excel
- Adding Time Values from Separate Hours and Minutes Columns
- Calculating Total Time Worked on a Specific Day
- Separating First and Last Names
- Finding the maximum value of all those meeting a certain criteria.
- Multiplying time values and numbers.
- Adding a Number to a Formatted Time Value
- Converting Time Values from One Time Zone to Another
- Subtracting Times
- Calculating the Number of Business Days in a Specified Period
- Calculating the Number of Weekday Hours Between Two Dates
- Avoiding Errors When Subtracting Times
- Calculating the Week Number Corresponding with a Specific Date
- Calculating Hours Worked
- Calculating Absolute Difference between Two Time Values
- Entering Dates Quickly
- Calculating Number of Days, Weeks, Months and Years between Dates
- Calculating a Date Based on Year, Week Number and Day of the Week
- Finding the Last Day of a Given Month
- Calculating the Number of Business Days in a Specified Period
- Calculating a Project's End Date
- Calculating a Required Date According to Two Criteria
- Indicating Due Payments, Based on the Current Date
- Calculating the Date of the Nth Specific Day of the Month
- Eliminating Negative Values from Date Subtractions
- Avoiding Negative Values when Calculating the Number of Days between Two Dates
- Avoiding False Results when Counting Dates Matching Specified Criteria
- Calculating the Week Number Corresponding with a Specific Date
- Determining whether Two Given Dates Occur within the Same Week
- Finding the Number of Days in a Given Month
- Finding the Serial Number of the Last Day of the Month
- Adding a Specified Number of Months to a Date
- Converting a Month's Serial Number into Its Corresponding Name
- Calculating the Quarter Number for Calendar and Fiscal Year
- Converting a Date into a String, Indicating the Quarter Number and Year
- Determining Which Quarter a Specified Date Corresponds With
- Converting Older Dates to the Current Year
- Converting a Julian Date to a Calendar Date
- Entering Times Quickly
- Entering Times Quickly
- Adding Time Values
- Adding Text Values Representing Time
- Adding Time Values from Separate Hours and Minutes Columns
- Adding a Number to a Formatted Time Value
- Subtracting Times
- Converting a Decimal Value to a Time Value
- Converting Text Representing Minutes and Seconds into Numerical Values
- Converting Times to Decimal Values
- Calculating Military Time Intervals
- Converting Time Values from One Time Zone to Another
- Creating a World Time Converter
- Rounding Times Down to the Nearest 30 Seconds
- Rounding Times Down to a Specified Time Increment
- Rounding Hours Up
- Calculating a Building's Occupancy Rate at Specified Times
- Creating Date and Time Stamp
- Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)
- Combining Data from Separate Columns into a Single Date and Time Value
- Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
- Calculating the Number of Weekday Hours between Two Dates
- Separating Dates and Times
- Creating a Date and Time Matrix
- Creating a Timesheet
- Finding the First Login and Last Logout Times of Employees
- Calculating Total Time Worked on a
- Calculating the Number of Hours Worked Based on a System of Letter Codes
- Calculating Total Pay, Based on Hours Worked Per Day and Hourly Rates
- Calculating Daily Pay, Incorporating Variable Hourly Rates
- Determining Whether a Person Worked a Full or Partial Shift
- Determining Whether a Worked Shift Was Morning, Afternoon or Night
- Counting the Number of Shifts in a Specified Week that an Employee Worked Overtime
- Calculating the Number of Hours per Month, Allowing for Daylight-Saving Shifts
- Counting Vacation or Sick Days within a Specified Time Period
- Calculating Hourly Productivity
- Avoiding Errors when Using the And Function to Combine Multiple Conditions in Array Formulas
»Click here to submit a tip to Excel Date & Time Formulas tips
