Alex, Two things:
• If you enter only the time in the field, Numbers will automatically figure it out for you. That is, enter 10:31 and Numbers will consider that cell a time entry. If you want 7:36 pm, enter 19:36 and numbers will translate it for you or enter 7:36 followed by a space then the "pm" and Numbers will also automatically treat this cell as time. • Regarding the entry of Date & Time in the cell, you need to fix this within the Inspector. That is, choose the Date & Time format, but then navigate right and set the Date to "None" and then right again to set the Time to your desired format. HTH. Later... Tim Kilburn Fort McMurray, AB Canada On 2013-10-09, at 10:50 PM, Alex Hall <[email protected]> wrote: > Hi again, > In Numbers, I want a time-only column of cells. I have found out I need the > Inspector, and I tried to create a time format then use the inspector to > apply it. If I choose the default "date and time" format, it works, but > "1245" turns into "12:45, January 1" or some such thing. I only need the > time, but I need Numbers to know to treat these cells as times, not regular > numbers, so math done on their contents comes out right. > > So, in the format creation window, I went to the text field where vo reported > a bunch of "embedded" items that looked like placeholders for where values > go. I erased all the date-related ones and left the time ones in, but that > does not seem to do it. after that field were a bunch of other embedded items > in their own text fields; do I need to do something with those instead/as > well, or did I set up the format right but apply it wrong somehow? Thanks for > your patience as I figure all this out! Oh, and yes I googled it, but > *everything* is for Excel and is just how to create formats, not what to do > if they don't work. > > > Have a great day, > Alex (msg sent from Mac Mini) > [email protected] > > > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/groups/opt_out.
