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
|