You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new 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

Top-ranking reply

Badunit

Level 7

27,982 points

Posted on Sep 21, 2022 1:35 PM

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.

View in context

Similar questions

4 replies

Top-ranking reply

Badunit

Level 7

27,982 points

Sep 21, 2022 1: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.

SGIII

Level 8

35,972 points

Sep 21, 2022 6: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.

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

Thanks Bedunit,

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

Sep 23, 2022 2: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.

Time without a date in Numbers