Time

[changetires]

I want my date and time to display as military time input and eliminate those pesky seconds digits that keep showing up? How do I do this?

Ed

[Die_Another_Day]

Format Custom HH:MM

HTH

Die_Another_Day
changetires wrote:
> I want my date and time to display as military time input and eliminate
> those pesky seconds digits that keep showing up? How do I do this?
>
> Ed
>
>
> --
> changetires
> ------------------------------------------------------------------------
> changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
> View this thread: http://www.excelforum.com/showthread...hreadid=560442

[Nick Hodge]

Ed

Format>Cells>Custom enter hh:mm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"changetires" <changetires.2asrz5_1152648908.5907@excelforum-nospam.com>
wrote in message
news:changetires.2asrz5_1152648908.5907@excelforum-nospam.com...
>
> I want my date and time to display as military time input and eliminate
> those pesky seconds digits that keep showing up? How do I do this?
>
> Ed
>
>
> --
> changetires
> ------------------------------------------------------------------------
> changetires's Profile:
> http://www.excelforum.com/member.php...o&userid=35414
> View this thread: http://www.excelforum.com/showthread...hreadid=560442
>