Joined: 04 Aug 2009
Location: United States
Online Status: Offline
Posts: 26
Topic: converting military time Posted: 11 Aug 2009 at 12:06pm
I have data that I am trying to convert from Military time. The data shows up like this 2359 so I created the following formula to put the Colon in the middle
if length ({RECMAST.TRANS_END_TIME}) =4 then picture ({RECMAST.TRANS_END_TIME}, "XX:XX")
now the time shows up as 23:59
now i need to convert the military to regular time can someone please help me with this?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
