| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Change text (0130PM) into military time equivalent?
I'm trying to change times that are reported in text format (ie 0830PM
instead of 8:30PM) into military time equivalents. Is there a straightforward way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I Change text (0130PM) into military time equivalent?
Try something like this:
For a text-time in A1 (example: 0830PM) B1: =TEXT(LEFT(A1,4)+(RIGHT(A1,2)="PM")*1200,"0000") Is that something you can work with? *********** Regards, Ron XL2002, WinXP "sedoc" wrote: I'm trying to change times that are reported in text format (ie 0830PM instead of 8:30PM) into military time equivalents. Is there a straightforward way to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I Change text (0130PM) into military time equivalent?
Yes, that works.
I just then have to change all the 2400's to 1200's since 1200 is noon, and 0000 is midnight Do you know of a way to do that? I'm working on it myself. Sara "Ron Coderre" wrote: Try something like this: For a text-time in A1 (example: 0830PM) B1: =TEXT(LEFT(A1,4)+(RIGHT(A1,2)="PM")*1200,"0000") Is that something you can work with? *********** Regards, Ron XL2002, WinXP "sedoc" wrote: I'm trying to change times that are reported in text format (ie 0830PM instead of 8:30PM) into military time equivalents. Is there a straightforward way to do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I Change text (0130PM) into military time equivalent?
Try this:
=TEXT(TIMEVALUE(LEFT(A1,2)&":00 "&RIGHT(A1,2))*2400+MID(A1,3,2),"0000") Does that help? *********** Regards, Ron XL2002, WinXP "sedoc" wrote: Yes, that works. I just then have to change all the 2400's to 1200's since 1200 is noon, and 0000 is midnight Do you know of a way to do that? I'm working on it myself. Sara "Ron Coderre" wrote: Try something like this: For a text-time in A1 (example: 0830PM) B1: =TEXT(LEFT(A1,4)+(RIGHT(A1,2)="PM")*1200,"0000") Is that something you can work with? *********** Regards, Ron XL2002, WinXP "sedoc" wrote: I'm trying to change times that are reported in text format (ie 0830PM instead of 8:30PM) into military time equivalents. Is there a straightforward way to do this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I Change text (0130PM) into military time equivalent?
EXCELLENT!!
Thanks Sara "Ron Coderre" wrote: Try this: =TEXT(TIMEVALUE(LEFT(A1,2)&":00 "&RIGHT(A1,2))*2400+MID(A1,3,2),"0000") Does that help? *********** Regards, Ron XL2002, WinXP "sedoc" wrote: Yes, that works. I just then have to change all the 2400's to 1200's since 1200 is noon, and 0000 is midnight Do you know of a way to do that? I'm working on it myself. Sara "Ron Coderre" wrote: Try something like this: For a text-time in A1 (example: 0830PM) B1: =TEXT(LEFT(A1,4)+(RIGHT(A1,2)="PM")*1200,"0000") Is that something you can work with? *********** Regards, Ron XL2002, WinXP "sedoc" wrote: I'm trying to change times that are reported in text format (ie 0830PM instead of 8:30PM) into military time equivalents. Is there a straightforward way to do this? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I Change text (0130PM) into military time equivalent?
This also works:
=TEXT(LEFT(A1,2)&":"&MID(A1,3,2)&" "&RIGHT(A1,2),"hhmm") Does that help? *********** Regards, Ron XL2002, WinXP "sedoc" wrote: Yes, that works. I just then have to change all the 2400's to 1200's since 1200 is noon, and 0000 is midnight Do you know of a way to do that? I'm working on it myself. Sara "Ron Coderre" wrote: Try something like this: For a text-time in A1 (example: 0830PM) B1: =TEXT(LEFT(A1,4)+(RIGHT(A1,2)="PM")*1200,"0000") Is that something you can work with? *********** Regards, Ron XL2002, WinXP "sedoc" wrote: I'm trying to change times that are reported in text format (ie 0830PM instead of 8:30PM) into military time equivalents. Is there a straightforward way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you change the Text Import Wizard column options | Excel Discussion (Misc queries) | |||
| how i change thai text to english text | Excel Worksheet Functions | |||
| Change number format from text to number? | New Users to Excel | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Time Stamp without change | Excel Discussion (Misc queries) | |||
Hybrid Mode
