|
|
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:
(3 Ratings)
Rate this link
Total 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
by Dave
Updated Sep 02, 2004
Rating:
N/A
Rate this link
Total Visits: 455
|
| Date & Time
|
Update Link / Bad Link? |
|
Miscellaneous pieces of advice regarding Date and Time in Excel.
Submitted Sep 28, 1999
Rating:
N/A
Rate this link
Total 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:
(3 Ratings)
Rate this link
Total Visits: 347
|
| 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:
(1 Ratings)
Rate this link
Total 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
Updated Nov 02, 2004
by Simone
Rating:
(1 Ratings)
Rate this link
Total 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:
N/A
Rate this link
Total 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:
N/A
Rate this link
Total 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:
N/A
Rate this link
Total 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:
N/A
Rate this link
Total Visits: 93
|
| 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. |
|
Update a Link
Recent Links 
Newsletter 
My Profile 
Link
To Us