Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page