Home > Excel > Time and Date
Top-Rated Links 
Most-Visited Links 

Time and Date

Excel and dates and times Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 1363
Advanced Excel Timesheet Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 457
Date & Time Update Link / Bad Link? 
Miscellaneous pieces of advice regarding Date and Time in Excel.
Submitted: Sep 28, 1999
Rating: 0.00   Rate this linkTotal Visits: 419
Date And Time Entry Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 348
Date Intervals Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 247
DATEDIF Function Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 216
Review: Dates And Times Update Link / Bad Link? 
A comprehensive review of the use of times and dates in Excel.
Submitted: Sep 07, 1999
Rating: 0.00   Rate this linkTotal Visits: 201
Julian Dates Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 189
Time Formatter Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 126
Adding Months And Years Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 93
  Link To Us

Terms of Use:  
NOTICE: Links you submit to Mathtools.net Link Exchange will be accessible from any part of the world via the web. Any information such links contain may be used by The MathWorks and the public, both within and outside the country from which you posted. Read complete disclaimer prior to use.


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