Charting with Times

[Matt Leach]

Im looking to create a chart who's y axis is based on times.

I have a notes table with the following structure:

starttime = auto enter timestamp

endtime = set by script when user saves note (button on layout)

totaltime = endtime - starttime

I have also created another summary field called grandtotaltime = Total of totaltime

I created a chart with the y axis as grandtotaltime and the y axis goes from 0, 10000, 20000, etc ...

Is it possible to have the chart display the y axis in HH:MM:SS format?

It seems that filemaker is ignoring the time formatting and displaying the y axis as a whole number

Is what im wanting to do possible?

Edited October 6, 2010 by Guest