convert to military time in excel

Roxanne · Apr 3rd, 2002, 04:12 PM

I am having trouble converting time to military time. Excell gives me the choice in format but when I select the format it does not change to military time in the column I am trying to change. The data comes from boxcar pro (a data logger for temperature and time) and is exported to excel. Can anyone out there help me??

Jack in the UK · Apr 3rd, 2002, 04:34 PM

Thanks to Bill Jelen (MrExcel)

see

http://www.mrexcel.com/tip029.shtml

dk · Apr 3rd, 2002, 04:35 PM

What does the data look like as it is i.e. before formatting?

Dan

Mark W. · Apr 3rd, 2002, 04:36 PM

Quote:

On 2002-04-03 15:12, Roxanne wrote:
I am having trouble converting time to military time. Excell gives me the choice in format but when I select the format it does not change to military time in the column I am trying to change. The data comes from boxcar pro (a data logger for temperature and time) and is exported to excel. Can anyone out there help me??

Roxanne, it's quite possible that your values were imported as text (e.g., "17:00"). This can be easily remedied if you'll select the column containing your times, choose the Data | Text to Columns... menu command, and press its [ Finish ] button.

IML · Apr 3rd, 2002, 04:37 PM

Quote:

On 2002-04-03 15:12, Roxanne wrote:
I am having trouble converting time to military time. Excell gives me the choice in format but when I select the format it does not change to military time in the column I am trying to change. The data comes from boxcar pro (a data logger for temperature and time) and is exported to excel. Can anyone out there help me??

Excel is probably treating your number as text. If this is the case, two possible fixes are
1) Select your column. goto data - text to columns and hit finish. Your format should now "stick"
2) By formula. Put
=TEXT(A1+0,"HH:MM:ss")
next to cell A1 and copy it down.

good luck

ufgatordad · Oct 11th, 2009, 01:51 PM

http://www.mrexcel.com/tip029.shtml

How do I change the event handler code for only one column that is referenced in the above tip?

taigovinda · Oct 11th, 2009, 02:13 PM

Quote:

Originally Posted by ufgatordad

http://www.mrexcel.com/tip029.shtml

How do I change the event handler code for only one column that is referenced in the above tip?

Welcome to the board!

Where he has under "possible enhancements"

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    ThisColumn = Target.Column
    If ThisColumn < 3 Then

You can change the "<" to "=" and then it will work only on column C (aka column 3).

Apr 3rd, 2002, 04:34 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Thanks to Bill Jelen (MrExcel) see http://www.mrexcel.com/tip029.shtml __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Oct 11th, 2009, 01:51 PM	#6
ufgatordad New Member Join Date: Oct 2009 Posts: 1	Re: convert to military time in excel http://www.mrexcel.com/tip029.shtml How do I change the event handler code for only one column that is referenced in the above tip?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 04:12 PM	#1
Roxanne New Member Join Date: Apr 2002 Posts: 1	I am having trouble converting time to military time. Excell gives me the choice in format but when I select the format it does not change to military time in the column I am trying to change. The data comes from boxcar pro (a data logger for temperature and time) and is exported to excel. Can anyone out there help me??

Apr 3rd, 2002, 04:35 PM	#3
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	What does the data look like as it is i.e. before formatting? Dan