Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BobMcConnell

    I need to get a regular time value from a military time

    I posted the formula, but it's still not working!
  2. BobMcConnell

    I need to get a regular time value from a military time

    SORRY, DIDN'T SEE YOUR LAST MESSAGE - HERE IS THE FORMULA Time (val(Left(ToText({{vSubjectAppointment.BeginTime}},0,""),2)), val(Right(ToText({{vSubjectAppointment.BeginTime}},0,""),2)), 0)
  3. BobMcConnell

    I need to get a regular time value from a military time

    BRIAN, THANKS FOR THE HELP BUT WHEN I PLUG THE FIELD NAME WHICH IS A NUMBER INTO THE FORMULA I GET AN ERROR THAT SAYS THE FIELD DOES NOT EXIST. ANY IDEAS
  4. BobMcConnell

    I need to get a regular time value from a military time

    Brian, Thank you for your help - especially so quickly. When I paste in this formula (the field is a number) and replace table.field with the fieldname I get the message "The field name is not known". What am I doing wrong?
  5. BobMcConnell

    I need to get a regular time value from a military time

    the values are 1000 1400 1600
  6. BobMcConnell

    I am trying to get averages and numbers by weeks

    Date avg num avg 4/14/2004 35 35 70 4/15/2004 33 87 65 4/16/2004 34 72 60 4/17/2004 32 67 22 4/18/2004 30 22 34 WEEKLY...

Part and Inventory Search

Back
Top