negative time value

  1. F

    Pivot Table Not Displaying Negative Time Values

    Hi everyone I have a pivot that needs to show a planned journey time, actual journey time and then the variance. The problem I have is that the calculated field in the pivot won't display the negative values in the variance where the journey took less time than planned. It just displays...
  2. J

    Time sheet formula question

    I created a weekly time sheet to calculate my total hours worked, based off of an example I found online. It has been working very well for me for over a year. However, it just occurred to me recently that while the sheet is calculating "overtime hours", it does not calculate remaining hours to...
  3. J

    Charting negative time values

    I can't find a way to chart and display negative time values. I already changed my workbook to the 1904 date system and I am able to get a negative time to display in the cell but it doesn't transfer over to the chart. For example; I am using a simple bar chart and a -1:29 will display as a...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top