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