Time always set to 12:00 AM when inserting Date & Time

my next question was going to be how are you typing in the numbers?

i got the same thing, but only when i typed a whole number, when i type an actual time, like 1:05 or 14:10 I get the right thing.

Jason

May you look at the System Preferences Pane entitled International?

Enter the "Formats" area.

Maybe the time is formatted this way:



You may select the PM item and delete it to get the 24 hours format.

Testing this behavior, I discovered that I was able to edit the median date format which was 01 janv. 2009. I replaced it by 01/01/2009 and now, at last, when I enter a date it defaults to my preferred format: dd/mm/yyyy 😉

Yvan KOENIG (from FRANCE samedi 17 janvier 2009 20:57:22)

Numbers grabs it's default format from the System's settings.

When I set the system time format to 10:12:PM, Numbers defaults to 10:12:PM

When I set it to 10:12, which was my own setting, Numbers defaults to 10:12

When I set it to 10:12:34, which is my new setting, Numbers defaults to 10:12:34.

Yvan KOENIG (from FRANCE samedi 17 janvier 2009 21:44:14)

1) I must disagree with your statement (of course this is just my personal opinion):

The whole point of spread sheet programs is for you to be easily able to enter things like the current date and time with ease

The purpose of a spreadsheet is to automate and make faster the CALCULATIONS you must do on the data you enter. It has nothing to do with ease of entry. Look back to the original desktop spreadsheet from DOS Visicalc. no specialized data entry, just calculations made faster on that data. Thats where I look to see what a program is meant to do. Look at the original.

2) I know why it is typing 12:00 am, Because it is never typing a time in when it inserts the date. Now why this is, I do not know. That might be a bug.

*If anyone else knows how to get the insert menu ti insert the date and time with time included, that would help alot.*

IF we cannot figure ti out, then we all need to submit a bug report via the feedback tool. They might slip that into an incremental update.

Jason

Reposting from above, because I responded to a post in the middle, not the bottom one...

1) I must disagree with your statement *(of course this is just my personal opinion)*:

The whole point of spread sheet programs is for you to be easily able to enter things like the current date and time with ease

The purpose of a spreadsheet is to automate and make faster the CALCULATIONS you must do on the data you enter. It has nothing to do with ease of entry. Look back to the original desktop spreadsheet from DOS Visicalc. no specialized data entry, just calculations made faster on that data. Thats where I look to see what a program is meant to do. Look at the original. *But thats just my opinion*.

2) I know why it is typing 12:00 am, Because it is never typing a time in when it inserts the date. Now why this is, I do not know. That might be a bug.

+*If anyone else knows how to get the insert menu ti insert the date and time with time included, that would help alot.*+

IF we cannot figure ti out, then we all need to submit a bug report via the feedback tool. They might slip that into an incremental update.

Jason

thats what i was saying in my response, I get the same thing because it only puts in the date and not the time. 😟

Does anyone know how to get the insert date & time to insert the time with the date?

Thanks,
Jason

i know how to set up the cells. I used the insert menus insert date and time like you stated into a properly formatted column of data. I get a date, but no time. Which would give you 12:00 am since it assumes midnight when no time is inputed.

I can confirm the problem. I just create a table, set one column to display time only and another to display date and time. When I select Insert -> Date & Time, only the date gets filled in on either of the two cells. Once I press return, the time is set to 00:00:00.

When the date is first filled in, the cursor is at the end of the date string. By hitting a space I can manually enter a time, but that hardly seems like that should be something I have to do since the menu options clear says Date & Time.