I'm sorry if I am in the wrong part of the Forum but I have suddenly come up against a problem with Excel that has never been there before and I wonder if I have maybe pressed some key along the way!
I have spreadsheets where I put the time into a cell in hrs:mins:secs - have been doing this for ages, years in fact, then suddenly last week I formatted the cells as usual to bring up the entry in hrs:mins:secs and every time I enter data, for instance 01:44:15, I get 15:00 showing up in the cell. I have checked and double checked the formatting and it is definitely set to show the hrs:mins:secs as I usually do. What on earth have I done????
Bookmarks