• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 432
  • Last Modified:

Cross Tab and Graph Question

I have a graph and cross tab that currently use a plots time in minutes for each day. I want to be able to display the time in hh:mm:ss format on the graph and cross tab.

I usually use the formula below to display the time in the format hh:mm:ss, but am unsure on how this would apply to a cross tab and graph.

WhilePrintingRecords;
NumberVar TotalSec :=  {@Timeworked};

NumberVar Hours   := Truncate  (Remainder ( TotalSec , 86400) / 3600) ;
NumberVar Minutes := Truncate  (Remainder ( TotalSec , 3600) / 60) ;
NumberVar Seconds := Remainder (TotalSec , 60) ;

Totext ( Hours ,   '00' ) +  ':' +
Totext ( Minutes , '00' ) +  ':' +
Totext ( Seconds , '00' )

0
halifaxman
Asked:
halifaxman
  • 2
1 Solution
 
mlmccCommented:
You can't use it on the graph because graphs are done before the Printing of the report.

See this link
http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_charting_print_time_formulas.pdf.asp

For the cross tab can you simply add the field?

mlmcc
0
 
mlmccCommented:
Glad i could help

mlmcc
0
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now