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
Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation
Site Developed By: Irubin Consulting