+ Reply to Thread
Results 1 to 4 of 4

Formula for computing work time in Excel

  1. #1
    Alex Vinokur
    Guest

    Formula for computing work time in Excel

    Hi,

    For instance, A1 = 8:20, B1 = 16:30.
    I need to compute in C1 the following: B1 - A1 - 0.5 hour.

    What is the formula?

    If I use formula B1 - A1 - 0:30 I get invalid value.

    Thanks,

    --
    Alex Vinokur
    email: alex DOT vinokur AT gmail DOT com
    http://mathforum.org/library/view/10978.html
    http://sourceforge.net/users/alexvn






  2. #2
    Bob Phillips
    Guest

    Re: Formula for computing work time in Excel

    =B1-A1-TIME(0,30,0)

    --
    HTH

    Bob Phillips

    "Alex Vinokur" <alexvn@big-foot.com> wrote in message
    news:uGyW$ZgvFHA.2008@TK2MSFTNGP10.phx.gbl...
    > Hi,
    >
    > For instance, A1 = 8:20, B1 = 16:30.
    > I need to compute in C1 the following: B1 - A1 - 0.5 hour.
    >
    > What is the formula?
    >
    > If I use formula B1 - A1 - 0:30 I get invalid value.
    >
    > Thanks,
    >
    > --
    > Alex Vinokur
    > email: alex DOT vinokur AT gmail DOT com
    > http://mathforum.org/library/view/10978.html
    > http://sourceforge.net/users/alexvn
    >
    >
    >
    >
    >




  3. #3
    Gary''s Student
    Guest

    RE: Formula for computing work time in Excel

    That's because time is really just a floating point number.

    1 is 1 day
    and hour is 1/24
    a half hour is 1/48

    =B1 - A1 - 1/48

    will work just fine
    --
    Gary''s Student


    "Alex Vinokur" wrote:

    > Hi,
    >
    > For instance, A1 = 8:20, B1 = 16:30.
    > I need to compute in C1 the following: B1 - A1 - 0.5 hour.
    >
    > What is the formula?
    >
    > If I use formula B1 - A1 - 0:30 I get invalid value.
    >
    > Thanks,
    >
    > --
    > Alex Vinokur
    > email: alex DOT vinokur AT gmail DOT com
    > http://mathforum.org/library/view/10978.html
    > http://sourceforge.net/users/alexvn
    >
    >
    >
    >
    >
    >


  4. #4
    Alex Vinokur
    Guest

    Re: Formula for computing work time in Excel


    "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message news:%2310nougvFHA.3100@TK2MSFTNGP12.phx.gbl...
    > =B1-A1-TIME(0,30,0)


    Thanks, Bob!

    It works fine.

    [snip]

    --
    Alex Vinokur
    email: alex DOT vinokur AT gmail DOT com
    http://mathforum.org/library/view/10978.html
    http://sourceforge.net/users/alexvn




+ 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