Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    May 2005
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Deducting time from time (2003)

    Almost 5pm Friday afternoon and I have a huge block.
    I have to deduct time from time.
    I refer to say, cell B4. B4 contains 13:30 (24 hour clock)
    In the other cell I want to say =B4 minus 30 minutes...

    How do I do that again ???

    Thanks

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Deducting time from time (2003)

    Welcome to the lounge.

    The following formula will work, recognizing that Excel assigns a value of 1 to a 24 hour day,

    =B4-30/24/60
    Regards
    Don

  3. #3
    Lounger
    Join Date
    May 2005
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Deducting time from time (2003)

    Thanks and have a great weekend

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Deducting time from time (2003)

    The formula that Don gave you will certainly work. I would like to add an additional way that might be a little easier to understand when you look at the formula again a year from now. The TIME() function can be used to convert a time into Excel's internal representation of time as fractions of a day. Therefore, you could also use the following formula:

    <code>
    =B4-TIME(0,30,0)
    </code>
    Legare Coleman

Posting Permissions

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