I have the following date format
5-APR-2007 00:01:01.06 and for the complete 24hr in a day.
like so:
5-APR-2007 00:01:01.06
5-APR-2007 00:02:01.11
5-APR-2007 00:03:01.13
5-APR-2007 00:04:01.16
5-APR-2007 00:05:01.20
5-APR-2007 00:06:01.22
5-APR-2007 00:07:01.25
5-APR-2007 00:08:01.28
5-APR-2007 00:09:01.31
5-APR-2007 00:10:01.34
5-APR-2007 00:11:01.37
5-APR-2007 00:12:01.40
5-APR-2007 00:13:01.42
5-APR-2007 00:14:01.45
5-APR-2007 00:15:01.47
5-APR-2007 00:16:01.51
5-APR-2007 00:17:01.55
5-APR-2007 00:18:01.57
I want to display the day-month-year and just the seconds for charting but when using format a cell for date or time like 3/14/01 13:30, I'm not able to change it.
I also want to limit the number of dates to say every minute when charting the dates and time but when looking at the scale I don't see and option for setting seconds.
Thanks,
Tom