Time conversion
Just to add:
You still need to enter time with a colon. 21:00 or 9:00 PM for example. It will then display without the colon in your definition of military time. Using the colon for entry tells excel that it is a time value. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... if this is data entered in cells as a time value, the all you need to do is select the cell and do Format=Cells go to the number tab, select custom and then enter a custom format like hhmm -- Regards, Tom Ogilvy "Mike" wrote in message ... Looking for a way to convert time (9:00 PM) to military time (2100) Any suggestions appreciated Thanks in Advance Mike |
All times are GMT +1. The time now is 03:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com