Split Military time over fields


G

Guest

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
 
Ad

Advertisements

G

Guest

=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
 
G

Guest

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)
 
G

Guest

Glad it worked for you...........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top