In the '09 version of Numbers (version 2.3), I was able to enter durations like "3:15" for 3 hours and 15 minutes. In the latest version (3.5), this doesn't work. I know I can enter "3h 15m" but I'd really like to be able to use "3:15". What are the odds of this feedback getting relayed to the developers?
MacBook Pro with Retina display, Mac OS X (10.0.x)
If you format the cells as Duration prior to entering the duration, you can use colon format to enter a duration but you have to enter it as 3:15:0 for it to be hours and minutes. If you do not pre-format the cells as duration, if you enter 3:15 or 3:15:0 it will make it a Date & Time of today at 3:15AM.
Numbers seems to default to a Date & Time format unless the number cannot be a time. If you enter 195:0, you will get 3h 15m. I found that if you enter 0:3:15:0 in a cell formatted as "automatic", you will also get a duration of 3h 15m.
Using the "00:00" option works if I want "3:15" to mean 3 minutes and 15 seconds, but I want it to specify 3 hours and 15 minutes.
As I said, my answer was a cheat rather than a solution.
Thank you. This looks similar to the first solution I had implemented (partially), and I will check it out. Thanks!
This is now my NEW(est) solution. Thanks!
Brilliant - just what I was looking for! Thank you.
Entering a duration using colon format
