Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Trying again for time in tenths of an hour.

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    With you sir im very sure it will do what i need, only to try it is left. thank you again.

  2. #12
    Board Regular
    Join Date
    Mar 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ok its up and running. But i had to take the a for am and p for pm out of the pitcher. How can i get the input cells (start and end time) to take a & p and have no effect on the value? it gives #VALUE if entered now.

  3. #13
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,426
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    The formula
    =(F7+(F7
    works correctly.

    Ensure that you enter valid time in E7 and F7. Do NOT enter the times as TEXT. You can enter with for example
    5:15 p and 2:00 a and Excel will show as
    5:15 PM and 2:00 AM.

    Ensure that you format the cell (where you record the formula) as general or as number.



    [ This Message was edited by: Dave Patton on 2002-04-07 11:31 ]

    [ This Message was edited by: Dave Patton on 2002-04-07 11:33 ]

  4. #14
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi cblincoln43


    Sorry, small typo in my reply, should be.

    =IF(F7<0.5,F7*24,(F7-0.5)*24)

    Where F7 contains your time. The formula could be shortened some-what, but would be at the expense of readability and have no advantage.

    If you also want the AM and PM after the decimal use a Custom Format like:

    [<0.5]General;0.0"AM";0.0"PM"


    The other formula of Aladins Will return 17.5 for "5:30:00 PM", I assume you really want 5.5PM ?




    _________________
    Kind Regards
    Dave Hawley
    OzGrid Business Applications
    Microsoft Excel/VBA Training





    [ This Message was edited by: Dave Hawley on 2002-04-07 19:00 ]

    [ This Message was edited by: Dave Hawley on 2002-04-08 05:01 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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