Home > Excel > Time and Date

Time and Date

Excel and dates and times  
This page is a must if you are wanting to work with dates and times in an Excel spreadsheet. It explains how Excel stores dates and times, give the magic numbers needed for dates and times and date and time conversions and functions.
Submitted: Aug 23, 2002
Advanced Excel Timesheet  
The Time Sheet incorporates a 1, 2, 3, 4, or 5 week period with any week and/or day being optional. All you do is enter your employee names once, save as a Template and you are set.
Submitted: Aug 28, 2004
Date & Time  
Miscellaneous pieces of advice regarding Date and Time in Excel.
Submitted: Sep 28, 1999
Date And Time Entry  
This page describes the VBA procedures that will allow you to enter dates and times, without having to enter in the "/" or ":" separators. For example, you could enter 9298 and get the valid date 2-Sep-1998. Or you could enter 1234 and get the valid time 12:34:00 PM.
Submitted: Sep 07, 1999
Date Intervals  
This page describes a few methods for working with intervals of dates. Specifically, it address the questions of whether a date falls within an interval, the number of days that two intervals overlap, and how many days are in one interval, excluding those days in another interval. These formulas can be quite useful for scheduling applications, such as employee vacation schedules.
Submitted: Sep 07, 1999
DATEDIF Function  
The =DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented by Microsoft at least in MS Excel 2000 release 9.0.
Submitted: Sep 07, 1999
Review: Dates And Times  
A comprehensive review of the use of times and dates in Excel.
Submitted: Sep 07, 1999
Julian Dates  
This page describes various Excel formulas for working with Julian dates (dates in YYDDD format), including converting them to and from standard Excel dates, and adding days to Julian dates.
Submitted: Sep 07, 1999
Time Formatter  
Time Formatter formats 24 hour time designations into AM/PM format. Example: converts 16:30 to 4:30PM. Can convert any number of times at one time.
Submitted: Aug 31, 1999
Adding Months And Years  
Sometimes it is useful to be able to enter or calculate numbers that express a number of years and months. For example, you may have a list of birthdays, and want to determine the average age, in years and months. Or, perhaps, enter and sum a list of numbers in yy.mm format. This page describes a variety of formulas and methods for working with data in this format.
Submitted: Sep 07, 1999



  Privacy - Trademarks - Feedback - Terms of Use Copyright The MathWorks, Inc.