Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subtract time from a number (Excel 2000)

    This is my problem:
    I have a total number of hours 172 hrs and 30 minutes and need to subtract the value of a cell which is in time format hh:mm (it consists of a start time and finish time that are subtracted). The result should give me the number of hours left from a total possible hours in a month.
    How should I set up the 172 hrs 30 minutes so that if the overtime was 2 hrs 30 minutes my result would give me 170 hrs????

    Kind regards

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Subtract time from a number (Excel 2000)

    Excel date/time is based on days.

    The number of days = (172 + 30/60)/24 = 7.1875
    format to:
    [h]:mm
    and it will display "172:30"

    {NOTE: brackets are for ELAPSED time, allow hours >24, or if set min or sec >60}

    Steve

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subtract time from a number (Excel 2000)

    Thanks Steve.
    It worked.
    Your prompt reply saved my bacon!

    Lynden

Posting Permissions

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