| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split Military time over fields
I have time stored in Military time format. 17:30. When I try to split the
field in to one for hr and one for min. The time will split as 5 instead of 17 then 30 and then Pm in the last cell. How do I keep the 17? Thanks Connie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split Military time over fields
=INT(A1*24) formatted General will give you the 17
=((A1*24)-INT(A1*24))*60 formatted General will give you the 30 Vaya con Dios, Chuck, CABGx3 "ConnieB" wrote: I have time stored in Military time format. 17:30. When I try to split the field in to one for hr and one for min. The time will split as 5 instead of 17 then 30 and then Pm in the last cell. How do I keep the 17? Thanks Connie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split Military time over fields
how exactly are u splitting them?
i believe that using a substring function where you put the first two chars in a cell and the last 2 in another would work (provided that the time is formatted always HH:MM) -- thanks, kowalsky "ConnieB" wrote: I have time stored in Military time format. 17:30. When I try to split the field in to one for hr and one for min. The time will split as 5 instead of 17 then 30 and then Pm in the last cell. How do I keep the 17? Thanks Connie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split Military time over fields
Glad it worked for you...........thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "ConnieB" wrote: It Worked! Thank you so much for all your help. Connie "CLR" wrote: =INT(A1*24) formatted General will give you the 17 =((A1*24)-INT(A1*24))*60 formatted General will give you the 30 Vaya con Dios, Chuck, CABGx3 "ConnieB" wrote: I have time stored in Military time format. 17:30. When I try to split the field in to one for hr and one for min. The time will split as 5 instead of 17 then 30 and then Pm in the last cell. How do I keep the 17? Thanks Connie |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split Military time over fields
It Worked!
Thank you so much for all your help. Connie "CLR" wrote: =INT(A1*24) formatted General will give you the 17 =((A1*24)-INT(A1*24))*60 formatted General will give you the 30 Vaya con Dios, Chuck, CABGx3 "ConnieB" wrote: I have time stored in Military time format. 17:30. When I try to split the field in to one for hr and one for min. The time will split as 5 instead of 17 then 30 and then Pm in the last cell. How do I keep the 17? Thanks Connie |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split Military time over fields
=HOUR(A1)
=MINUTE(A1) -- David Biddulph "ConnieB" wrote in message ... I have time stored in Military time format. 17:30. When I try to split the field in to one for hr and one for min. The time will split as 5 instead of 17 then 30 and then Pm in the last cell. How do I keep the 17? Thanks Connie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| military time | Excel Discussion (Misc queries) | |||
| How to keep 0 for military time | Excel Discussion (Misc queries) | |||
| Military time comes up? | Excel Discussion (Misc queries) | |||
| Military Time | Excel Discussion (Misc queries) | |||
| Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions | |||
Linear Mode
