Using Apple's Numbers, I need to enter a time that is independent of a date. How can this be done?
MacBook Pro 13″, macOS 10.14
Pre-format the cells as text. You can use them as a times of day in math and functions. If necessary for a calculation, Numbers will attach the the current date to it.
If you format cells as text and then enter dates, note that date math will work as expected. But sorting won't, unless you use a format like 2022-09-22.
SG
Thanks Bedunit,
How text gets used as math is beyond me. But am glad this work.
Thanks SG,
The text approach is both working for me and leaving me mystified. But you can't beat success. Your help with this is appreciated.
Time without a date in Numbers
