Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Hours & Minutes (Office 97)

    Hi

    I have two fields date/time one called arrive and own called depart I deduct arrive from depart ie arrive 9.00 Depart 11.30 and the total field gives me 2.30
    I would like it to read 2 Hours 30 Mins. Can any one tell how to change this code =[Depart]-[Arrive] to read what I require

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hours & Minutes (Office 97)

    Set the Format property of the result to

    h" Hours "n" Mins"

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Hours & Minutes (Office 97)

    Hi

    Thanks for that

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Hours & Minutes (Office 97)

    Hi Hans

    I typed it in exactly as you said but it did not work! Is it something to do with the quote marks?

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Hours & Minutes (Office 97)

    Hi Hans

    My stupid mistake, very sorry. It works fine if do as I am told by an expert.

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Hours & Minutes (Office 97)

    Hi Hans

    I got it now I entered it wrong sorry about that.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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