times formula - formating

[Louie]

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

 

[Bob Greenblatt]

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.