I've been struggling with this for a while now. I would like the data in Column D to represent only minutes, such as 0:10:00. But, when the cells are formatted as [h]:mm:ss, Excel shows 12:10:00 AM in the formula bar. Is there any way around this to just show the data I enter as 0:10:00 rather than converting it to a 24-hour clock format?