+ Reply to Thread
Results 1 to 2 of 2

Accommodate inconsistent time format inputs

  1. #1
    Registered User
    Join Date
    12-06-2017
    Location
    Melbourne, Australia
    MS-Off Ver
    2013
    Posts
    1

    Accommodate inconsistent time format inputs

    I am designing a sheet to act as a form (not a Userform).
    The form then updates a database sheet via a macro.

    One of the fields is a time window for delivery.
    The upper and lower bounds are in different cells.
    One of the issues i foresee is different users inputting times in different formats.
    i.e. 13:30, 1:30 pm 1:30pm 13.30 1330 etc.

    It there a way I can accommodated these inputs such that the database is consistent.

    Thanks in advance.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    BE
    MS-Off Ver
    PC: 97 / 2016
    Posts
    5,382

    Re: Accommodate inconsistent time format inputs

    you can try this (24-hour)

    dv-time.jpg

    and custom format to: hh:mm
    sandy (NO CAPS)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1