How can you format cells in Excel to hold a minute:second format? All the forms of time formatting I have found have actual times in the cell, i.e. I can get it to read 15:45 (for 15 minutes and 45 seconds) but the actual value of the cell is 12:15:45 AM. Don’t want that, I just want to be able to be able to enter times in a minute:second format and be able to average the figures.
I’ve tried the help features and that damn paperclip knows nothing.