How do I prevent Excel from adding a date when custom formatting cells for hours and minutes?

I am building a spreadsheet with two columns of hours and minutes in each column so I can subtract the two to get the hours and minutes worked. I have made a custom format with hours in minutes and save it. When I go back to add a time ie. 7:08 it puts it in the field as 5/5/2025 7:08:00 am. I dont want the date since this will effect the calculations if I dont enter every number new each week. - If Someone starts at 7:00 today and works till 3:00 and the next week I have the same person start at 7:00 and work until 3:05 it will show 7 days and 8 hours because the date will be a week apart(the 7:00 start from the week before and the 3:05 from today.




[Re-Titled by Moderator]

Mac Studio, macOS 15.4

Posted on May 5, 2025 7:10 AM

Reply

Similar questions

4 replies

May 5, 2025 7:25 AM in response to williamleon

Date & Time in Numbers always has a date and a time even if you enter "just the time" and format the cell not to display a date. If you don't supply a date Numbers guesses that you mean the date on which you entered the value, helpful in many situations but not so helpful for what you want to do.


An easy workaround is to format the cells as Text and then enter the times. The values will display as left-aligned by default, but you can manually change the alignment if needed.


Numbers will happily perform "date arithmetic" on such "text times", e.g. subtracting one from the other to get the duration.


SG

May 5, 2025 10:04 AM in response to williamleon

You mention Excel, but show a Numbers spreadsheet. Which application is it you're working in?


Assuming Numbers, there is a specific data type - Duration - which is designed just for this purpose - a number of hours/minutes/seconds (or days, weeks... etc.), so maybe consider using that for your table?


In either case, date fields always inherently contain a date and a time. how you choose to display that is independent of the underlying cell value, and there are numerous Date & Time functions that can be used to extract the data you want from them.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do I prevent Excel from adding a date when custom formatting cells for hours and minutes?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.