I would like to enter times mm, seconds, milliseconds into google sheets and subtract times to determine duration.  I use format> numbers > More formats > more dates and times > and apply mm:ss: ms.I enter my numbers (e.g. 02:23 44), the cell contains text not number and the format shows automatic. It does not matter if I use colons or not (cells G6, G7).How can I enter times in the format of mm, ss, and milliseconds? I've tried duration format, the cells still ends up as text not numbers. I've tried using time (hh:mm:ss AM) - the times show up as numbers and I can display these with milliseconds. I tried copying the correctly formatted cells, but then I cannot insert the new times (no place for milliseconds). Any help would be appreciated - I've searched for similar problems but can't find exactly what I am looking for. if this can be done without formulas that would be great.  https://docs.google.com/a/gallaudet.edu/spreadsheets/d/1OSqbevioPmvCmEqKyWjT0xEmbrMI-X5crv16DMTQNDY/edit?usp=sharingBy the way, I noticed this question and reply about entering time. But the TIMEVALUE formula does not appear to have milliseconds. Any help on using the formula for getting ms would be great.Time duration formatting in Google Spreadsheets
entering mm:ss: milliseconds into Google Sheets for time duration (arithmetic)
google spreadsheets;formatting;duration