Time without a date in Numbers

Question

Time without a date in Numbers

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

Posted on Sep 21, 2022 11:31 AM

Reply

Answer 1

Top-ranking reply

Badunit

Level 7

29,868 points

Sep 21, 2022 01:35 PM in response to john@scriptwerx.com

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.

Reply

Answer 2

SGIII

Level 8

37,202 points

Sep 21, 2022 06:05 PM in response to john@scriptwerx.com

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

Reply

Answer 3

Sep 23, 2022 02:24 PM in response to Badunit

Thanks Bedunit,

How text gets used as math is beyond me. But am glad this work.

Reply

Answer 4

Sep 23, 2022 02:26 PM in response to SGIII

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.

Reply

Time without a date in Numbers

Similar questions