ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time (https://www.excelbanter.com/excel-discussion-misc-queries/98693-time.html)

changetires

Time

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

Die_Another_Day

Time

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

Time

Ed

FormatCellsCustom enter hh:mm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS

"changetires"
wrote in message
...

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

All times are GMT +1. The time now is 04:22 PM.