Hi, I’m a noobie and I want to record cd times in an .xls file.
What I want is for the times for each track to read like 4:32 for four minutes and thirty-two seconds. When I go to enter the time in the cell it comes up (xxx) and the formula bar says that 4:32 is 04:32:00AM.
How do I make it understand?
I’m running LibreOffice 4.2.3.3 in Linux Mint 17
Thank you for the help
-Frank
You need to put the 0 hours first, test with 0:4:32.