times formula - formating

Hello, I need to save some time and enter times just as numbers instead of
using the : each time I enter the time and minutes, like...0725 would equal
7:25 and have excel recognize that, or 1348 would equal 13:48. is there such
formating or formula to apply and just enter numbers?
thanks in advance for your help
--
Louie

On 7/31/08 7:17 PM, in article
A5545687-3568-4B91-8A38-5E346CAE3660 DeleteThis @microsoft.com, "Louie"
<Louie DeleteThis @discussions.microsoft.com> wrote:

> Hello, I need to save some time and enter times just as numbers instead of
> using the : each time I enter the time and minutes, like...0725 would equal
> 7:25 and have excel recognize that, or 1348 would equal 13:48. is there such
> formating or formula to apply and just enter numbers?
> thanks in advance for your help
If you want the number 0725 to be treated as a time, you'll have to parse it
and do the conversions with Excel formulas. If you want Excel to understand
it as time but not show the colons, just use a custom format of "hhmm". If
you do this, however, you will still have to enter the value as "07:25" in
order for Excel to understand it as a time; but it will display as 0725.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom