I have a time in my database that is in military time...sort of, without the colons. It looks like this in the database: 1400, 1430, 1500, etc.

How would I display this as regular am/pm time? Is there a way to convert this using ASP?

Thanks,
WebGrrl

If the hour > 12, subtract 12.

Okay, the next step then...

How would I insert the colon in the appropriate place?

For example, if the database gives me 1430, I can calculate that 1430 > 1200, then I can subtract 1200. Now I have 230. How do I insert the colon in the appropriate place?

Thanks,
WebGrrl

function military2normal(strMilitary)
  dim r,hours,ampm : r=""
  if len(strMilitary)>0 and isnumeric(strMilitary) then
    hours=cint(left(strMilitary,2))
    if hours<12 then ampm=" AM" else ampm=" PM"
    if hours=0 then hours=12
    if hours>12 then hours=hours-12
    r=hours & ":" & right(strMilitary,2) & ampm
  end if
  military2normal=r
end function

Awesome, this works perfectly! Thanks a bunch!

WebGrrl

NP =)