+ Reply to Thread
Results 1 to 3 of 3

negative time calcualtions

  1. #1
    Registered User
    Join Date
    05-08-2018
    Location
    Manchester,England
    MS-Off Ver
    2010
    Posts
    1

    negative time calcualtions

    Hi,

    this may be really simple but having had several attempts I am hoping someone will be able to help.

    I am trying to work out a time balance. I need a formula to work out what a negative time plus a positive time would be e.g. -13:03 + 2:54 = -10:25 but I just keep getting #Value!

    I also need the final answer to be converted to minutes so if I can do this at the same time that would be great.
    Again, I cannot figure out how to display the negative hours into minutes.

    I have the 1904 data system ticked

    Thanks in advance for any help

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: negative time calcualtions

    This may help;

    https://excelribbon.tips.net/T013356...ive_Times.html

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,864

    Re: negative time calcualtions

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need a formula to change a negative time to negative decimal
    By Renejorgensen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-12-2016, 11:51 AM
  2. Replies: 8
    Last Post: 01-10-2014, 03:43 AM
  3. [SOLVED] How to do IRRs & NPVs calcualtions without the long cashflows?
    By thetalldude in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-17-2013, 11:56 PM
  4. [SOLVED] Complicated Look Up in an untidy file with calcualtions
    By Excel Dumbo in forum Excel General
    Replies: 6
    Last Post: 08-07-2013, 02:17 AM
  5. Time Calcualtions and #VALUE
    By espyder in forum Excel General
    Replies: 1
    Last Post: 06-11-2012, 10:01 AM
  6. Payroll calcualtions - nested IF?
    By bmz in forum Excel General
    Replies: 5
    Last Post: 02-15-2010, 01:08 PM
  7. Using displayed rounded numbers in subsequent calcualtions
    By 01mike in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-15-2006, 03:30 AM

Tags for this Thread

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