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. pumpkin31202

    Splitting a field

    Naith, Your formula worked. Thanks a lot. The only thing is now I need to sum the hours we just calculated, but the field is non-numeric. Any suggestions on that? Thanks, Pumpkin
  2. pumpkin31202

    Splitting a field

    The field contains visit times. Some examples are 800-920; 1000-1110; 1105-1220PM; 125PM-230PM; 1240PM-120PM. Whenever the time is in the afternoon or evening the system will place PM after it. The systems never includes AM. The smallest the field can be is 7 and the largest is 13.
  3. pumpkin31202

    Splitting a field

    Unfortenately, the field can be up to 13 characters.
  4. pumpkin31202

    Splitting a field

    I have a field that contains beginning and ending times. For example the field contains 1140-1240PM. I want to split the two times into two different fields so I can then do a caculation with them to determine the number of minutes there is between them. Can anyone help me do that?

Part and Inventory Search

Back
Top