Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Functions in Excel
I would really like more date/time options in Excel. Go look at what Matlab
provides. Some suggestions: - provide an option on the DATEVALUE function where the epoch (start date) is provided by the user. Matlab default is 1-Jan-0000. - provide an option for DATEVALUE function to specify the time of the epoch like 12:00:00 or something like this. - It would be great if there were canned functions to calculate number of days since the J2000 epoch or other common epochs. - It would be great if there were canned functions to translate the current time or a provided time into J2000 or a time relative to a provided epoch. - It would be helpful if the date and time functions would provide some more functions that allow input of date and time together and calculate the serial number of days ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Functions in Excel
"Paul" wrote in message
... I would really like more date/time options in Excel. Go look at what Matlab provides. Some suggestions: - provide an option on the DATEVALUE function where the epoch (start date) is provided by the user. Matlab default is 1-Jan-0000. - provide an option for DATEVALUE function to specify the time of the epoch like 12:00:00 or something like this. - It would be great if there were canned functions to calculate number of days since the J2000 epoch or other common epochs. - It would be great if there were canned functions to translate the current time or a provided time into J2000 or a time relative to a provided epoch. - It would be helpful if the date and time functions would provide some more functions that allow input of date and time together and calculate the serial number of days The DATEVALUE function does nothing but convert a text expression into a serial number date. If MS changed the date system it would probably destroy millions of workbooks. Are you saying that you cannot put date and time together in Excel or that you cannot count the serial number of days? -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
Changes in date functions between excel 2002 and 2003 | Excel Worksheet Functions | |||
Showing todays date when the Excel value is zero | Excel Worksheet Functions | |||
excel array formula | Excel Worksheet Functions | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) |