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

Hi Everyone,
When I try to insert the current TIME into a cell, it always formats it to 12:00 AM. Dates work fine. Help! Thanx

Mac OS X (10.5.6), Macbook Aluminum 2.4 Ghz

Posted on Jan 17, 2009 6:17 AM

37 replies

Jan 18, 2009 7:32 AM in response to jaxjason

Before we do that, let's make sure others are having this exact issue. Please format a cell for time only and insert "date & time" from the menu and report back what you see in the cell. Thanx

Kyd

Level 1

38 points

Jan 18, 2009 8:52 AM in response to DogDutyAscetic

I did exactly that and posted my results above...which if you (like me) quickly scroll to the bottom for new posts, would have missed it.

Jan 18, 2009 2:20 PM in response to Kyd

Ok, I didn't see your message. I'll make a bug report then. Thanx for your help everyone.

Apr 7, 2009 4:07 PM in response to DogDutyAscetic

I would like to add that I am experiencing the same bug almost 3 months later.

Apr 9, 2009 3:59 AM in response to KOENIG Yvan

That worked. Thank you.

Apr 9, 2009 5:10 AM in response to quantumhobbit

The right click menu worked. I can't get your script to work in Numbers though.

Dec 6, 2016 4:13 AM in response to Reg MH

Hello everyone,
I have the same problem in Numbers: When I insert the Date & Time in a Date formated cell, the time is always 12:00 AM. Do someaone knows if this bug is already resolved by Apple?
Thanks!!

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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