|
|
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
|
|
|
