Pivot using negative Time possible??

[mharald]

Hi, I want to make a pivot chart from the following table:

table.PNG

But the negative Values show without a number:

graph.PNG

Any ideas what I can do?

Thank you.

[XLent]

would the attached be of any help?

effectively uses a calculated field in the Pivot to replace the source time field, converting hours to integers and handling minute remainder {decimal} on a base of 60

Please Login or Register  to view this content.

you would then format this new field as Number (to 2dp) in resulting pivot/chart.

the above effectively converts the real time values such that the hour value becomes an integer (e.g. 12:00 goes from 0.5 to 12.0), and converts minutes from their true decimal value to their relevant value on base 60, e.g.:

- 12:30 * 24 --> -12.5 --> -12.30

so, in effect you're losing the "real" time format by replacing the : with . but you gain the advantage of being able to display negatives.

see attached for very basic illustration.