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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
I hope to use apple numbers spreadsheet for a time card for myself, to track billable hours for my architecture practice. What are some of the time functions to time stamp, etc.?
MacBook Pro 15″, macOS 10.14
Hi Luigi,
TIME will return the current time of day, but, like all other functions in Numbers, will refresh (with a new time) whenever there is a change made in the table.
The menu item Date&Time (in the Insert menu) will place the current Date and Time value at the insertion point, and initially display only the date part. To change the display to show only the time part, you'll need to option-click the cell showing the inserted Date, then choose the display tou want from the menu that pops up:
Note that the cell will still contain the full Data and Time value, but only the time part will be displayed.
Regards,
Barry
Hi Luigi,
TIME will return the current time of day, but, like all other functions in Numbers, will refresh (with a new time) whenever there is a change made in the table.
The menu item Date&Time (in the Insert menu) will place the current Date and Time value at the insertion point, and initially display only the date part. To change the display to show only the time part, you'll need to option-click the cell showing the inserted Date, then choose the display tou want from the menu that pops up:
Note that the cell will still contain the full Data and Time value, but only the time part will be displayed.
Regards,
Barry
Time card and time tracking formulas for Apple Numbers
