Does anyone have a good quick way of entering times, specifically durations, NOT time of day, into Excel? All of the times in this case will be short, minutes and seconds. Nothing as long as an hour, so I don't need the hour displayed, and I'd rather not have to type it every time.
I've come up with some shortcuts to streamline things a bit - My format is
m:ss;@, which displays what I want, but I still have to type
0:3:14 every time.
I've created a macro so that by typing
.. I get a
:, which is much quicker than having to constantly alternate between the shift-key being down for the colons and up for the numbers. (This also saves time since the
. is right there on the number pad so I can easily type one-handed without having to move my hand over to the
: and back every time.) Forget where I saw this suggestion but it's genius.
However, I still have to type
0..3..14. It requires me to type in the hour even though it's always 0. Is there any way that I can just type in
3..14. If I do that now, I end up with
3:14:00 instead of
0:03:14. May not seem like much, but when you have to do it hundreds of times, every little bit helps. (I tried cheating and pretending the hours and minutes were minutes and seconds, but where this fails is when I want to add up all the durations on the bottom - and the total will be in hours, even though the individual times are much shorter.