I didn't realize I could set the date to "none", I'll definitely give that a try. I also didn't enter a colon, because I'm so used to simple four-digit military time formats that I often omit it when I'm taking down times for my own use. I'll try that as well. Thanks. On Oct 10, 2013, at 10:13 AM, Tim Kilburn <[email protected]> wrote:
> 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. 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.
