Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

calculating time

Discussion in 'Information Technology' started by ILIRI, Jul 28, 2006.

  1. ILIRI

    ILIRI
    Expand Collapse
    Guest

    "ILIRI" <iiliri@gmail.com> wrote in message news:...
    > Can Anyone please help me with this situation.
    >
    > Q. I have previously designed databes on Access 97, now I am asked to put
    > some extra features on it which involve calculating time.
    >
    > What I wanted to do in form is adding another text box (ex. Box2) that
    > would show ([Box1] - 20 minutes). box1 already exists and contains data
    >
    >
    >
    > ------ ------
    > ¦ box1 ¦ ¦ box2 ¦
    > ------ ------
    >
    > - Box1 shows inputed time in format hhnn (ex, 2215) and box2 has same
    > format.
    >
    > I have already tried to put another textbox (box1a) that was not visible
    > in form view with default value 20 and format nn. Then on box2 i entered
    > source as: =[box1]-[box1a] but I didn't have apropriate result becaus
    > calculation dit not efected time but date in stead.
    >
    > how should I resolve this situation.
    >
     
  2. Loading...

    Similar Threads Forum Date
    SciTech Calculating the Rarity of a Fingerprint Breaking News Dec 13, 2010

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    ILIRI wrote:
    "ILIRI" <iiliri@gmail.com> wrote in message news:...
    > Can Anyone please help me with this situation.
    >
    > Q. I have previously designed databes on Access 97, now I am asked
    > to put some extra features on it which involve calculating time.
    >
    > What I wanted to do in form is adding another text box (ex. Box2)
    > that would show ([Box1] - 20 minutes). box1 already exists and
    > contains data
    >
    >
    > ------ ------
    > ¦ box1 ¦ ¦ box2 ¦
    > ------ ------
    >
    > - Box1 shows inputed time in format hhnn (ex, 2215) and box2 has same
    > format.
    >
    > I have already tried to put another textbox (box1a) that was not
    > visible in form view with default value 20 and format nn. Then on
    > box2 i entered source as: =[box1]-[box1a] but I didn't have
    > apropriate result becaus calculation dit not efected time but date
    > in stead.
    > how should I resolve this situation.



    Take a look at the DateDiff function.

    --
    Joseph Meehan

    Dia duit
     
  4. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Iliri,

    Here are some articles that you may find useful:

    On time and how much has elapsed
    http://office.microsoft.com/en-us/assistance/HA011102181033.aspx

    Using dates and times in Access
    http://office.microsoft.com/en-us/assistance/HA010546621033.aspx

    How to Calculate Daily Hours Based on Clock In/Clock Out Times
    http://support.microsoft.com/?id=237958


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "ILIRI" wrote:

    > Can Anyone please help me with this situation.
    >
    > Q. I have previously designed databes on Access 97, now I am asked to put
    > some extra features on it which involve calculating time.
    >
    > What I wanted to do in form is adding another text box (ex. Box2) that
    > would show ([Box1] - 20 minutes). box1 already exists and contains data
    >
    >
    >
    > ------ ------
    > ¦ box1 ¦ ¦ box2 ¦
    > ------ ------
    >
    > - Box1 shows inputed time in format hhnn (ex, 2215) and box2 has same
    > format.
    >
    > I have already tried to put another textbox (box1a) that was not visible
    > in form view with default value 20 and format nn. Then on box2 i entered
    > source as: =[box1]-[box1a] but I didn't have apropriate result becaus
    > calculation dit not efected time but date in stead.
    >
    > how should I resolve this situation.
     

Share This Page