hi there
thanks for all your help...
i'm entering a lot of data that looks like:
0:00
0:04
6:20
13:14, etc.
these are number of hours and minutes. is there a formatting shortcut i can use so i don't have to enter the colon and the preceeding zeros for each entry?
in other words, if i enter "1" EXCEL will enter "0:01". if i enter "647", EXCEL will enter "6:47", "100" becomes "1:00", etc.
thanks muchly!
thanks for all your help...
i'm entering a lot of data that looks like:
0:00
0:04
6:20
13:14, etc.
these are number of hours and minutes. is there a formatting shortcut i can use so i don't have to enter the colon and the preceeding zeros for each entry?
in other words, if i enter "1" EXCEL will enter "0:01". if i enter "647", EXCEL will enter "6:47", "100" becomes "1:00", etc.
thanks muchly!