Formatting a crosstab summary from seconds to MM:SS

I have a crosstab set up based on a formula that determines the number of seconds between two dates, and then finds the median. It works correctly using the seconds value.

Cross-Tab Summarized Fields:
Median of @DateDiffSeconds

However, I would like it to display in MM:SS format.

If I use the formula to create a CTime, Median isn't an allowed summary type.

I can't find a way to change the way it's displayed based on the calculations. (Like Group names, having a formula for calculating as well as a seperate one for displaying.)
Who is Participating?
Right click on your summary field in the cross tab.
Select Format Field.
Click on the formula icon next to Display String on the Common Tab.

Insert the following Formula:

numbervar hours := Truncate(CurrentFieldValue/60);

numbervar seconds := remainder(CurrentFieldValue, 60);

jb25Author Commented:
Worked perfectly. I didn't realize that there was an option to change the display string under Format Field.

Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.