Show Negative Time

gmazza76

Well-known Member
Joined
Mar 19, 2011
Messages
591
Office Version
  1. 365
Platform
  1. Windows
Good morning,

I am new to Power Pivot and could do with some help please.

I have 2 columns (Requested & Actual) showing time and I need to confirm if we are above or below the actual requested time allowance.

I want to show if the Actual is lower than the Requested in a time value.

I am using the formula below, but the calculation always shows the value but not in a negative (-) value if the Actual is less than the Requested

Code:
='Tablename'[Actual]-'Tablename'[Requested]

Sorry if this is a simple question
thanks in advance.
Gavin
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

rondeondo

Board Regular
Joined
Aug 15, 2012
Messages
156
Hi Gavin
what display format do you have set for your calculated value? what does it show, please provide example of the output

you could also wrap your calculation in an if
for example:
VBA Code:
=if('Tablename'[Actual] < 'Tablename'[Requested], "Text to denote better than requested" , "Text to denote after requested") & 
'Tablename'[Actual]-'Tablename'[Requested]
 

Watch MrExcel Video

Forum statistics

Threads
1,108,738
Messages
5,524,543
Members
409,583
Latest member
gkarthick

This Week's Hot Topics

Top