Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: I enter date and format for date, but shows as number spohar Excel Discussion (Misc queries) 2 March 10th 06 09:40 PM
Changes in date functions between excel 2002 and 2003 Wayne Excel Worksheet Functions 3 January 13th 06 02:52 PM
Showing todays date when the Excel value is zero David Hall Excel Worksheet Functions 1 January 7th 06 06:19 PM
excel array formula gordo Excel Worksheet Functions 14 October 18th 05 05:19 PM
User-defined functions created in Excel 2000 fail in Excel 2003 goodguy Excel Discussion (Misc queries) 1 October 3rd 05 07:04 PM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"