Converting military times to numbers
I have a column that contains times in military format. I want to convert the times to numbers, with no formatting. For example: Right now the columns show the following: 0:01 0:23 2:14 13:32 19:54 Their actual values a 12:01:00 AM 12:23:00 AM 2:14:00 AM 1:32:00 PM 7:54:00 PM I want it to instead have the following values: 1 23 214 1332 1954 They should be formatted as numbers, with no indication that they represent times. Is this possible? I have a worksheet that contains military times in number format that I need to compare against. Thanks. -- Wire323 ------------------------------------------------------------------------ Wire323's Profile: http://www.excelforum.com/member.php...o&userid=33218 View this thread: http://www.excelforum.com/showthread...hreadid=530374 |
Converting military times to numbers
Hi,
Would the following be of any help : =VALUE(TEXT(A1,"hhmm")) HTH Carim |
Converting military times to numbers
=HOUR(A1)*100+MINUTE(A1)
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Wire323" wrote in message ... I have a column that contains times in military format. I want to convert the times to numbers, with no formatting. For example: Right now the columns show the following: 0:01 0:23 2:14 13:32 19:54 Their actual values a 12:01:00 AM 12:23:00 AM 2:14:00 AM 1:32:00 PM 7:54:00 PM I want it to instead have the following values: 1 23 214 1332 1954 They should be formatted as numbers, with no indication that they represent times. Is this possible? I have a worksheet that contains military times in number format that I need to compare against. Thanks. -- Wire323 ------------------------------------------------------------------------ Wire323's Profile: http://www.excelforum.com/member.php...o&userid=33218 View this thread: http://www.excelforum.com/showthread...hreadid=530374 |
Converting military times to numbers
That works, thanks. I asked this question on a few different forums, and have gotten a few different answers. -- Wire323 ------------------------------------------------------------------------ Wire323's Profile: http://www.excelforum.com/member.php...o&userid=33218 View this thread: http://www.excelforum.com/showthread...hreadid=530374 |
All times are GMT +1. The time now is 01:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com