TIME

MONDLOC

New Member
Joined
Jan 23, 2004
Messages
4
I am inputting a lot of miltary time cells. Is there a way that i can set it up so that the colon will automatically appear when I enter the four digits? Thanks
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,113,794
Messages
5,544,322
Members
410,603
Latest member
rseckler
Top