I forgot to say that I can't use date/time fields, I need time only. When I set a field to be date and time, entering just a time gave me an automatic, and very wrong, date. That is why I wanted the custom format, so I could have times only and dates only. Yes, I need the cells to be properly typed (as in dates, times, currency, all that) so my formulas will work properly, but the default date/time field type is not going to work. On Oct 10, 2013, at 4:38 AM, Nicholas Parsons <[email protected]> wrote:
> HI Alex, > > I don't know the exact answer to your question in Numbers. IN Excel, however, > maths works on date fields even when they are displayed as dates. So you can > calculate the time difference between two dates, etcetera, just as if they > were regular numbers. So maybe you could try just using regular functions > with the date fields. If you've tried this already and it didn't work then > please just ignore this. > > Best, > Nic > > -- > 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.
