AngChristman
MIS
Hello,
I am having a problem with my formatting.
This is my formula:
WhilePrintingRecords;
NumberVar TotalSec := ({sfplan.mrtime}-{sfjobdet.mrtime});
NumberVar Hours := Truncate ( TotalSec / 3600);
NumberVar Minutes := Truncate (Remainder ( TotalSec,3600) / 60);
Totext ( Hours, '####') + ':'+
Totext ( Minutes,'00')
And my results show the 4 and the 28 in parentheses for being negative. Then I also did a highlight expert with if the results are < 0 to color red. 0 is coloring red and I didn’t set it up as < >= 0
( 4)28)
0:00
Any help you can give me will be greatly appreciated.
Thank you,
Angie Christman
I am having a problem with my formatting.
This is my formula:
WhilePrintingRecords;
NumberVar TotalSec := ({sfplan.mrtime}-{sfjobdet.mrtime});
NumberVar Hours := Truncate ( TotalSec / 3600);
NumberVar Minutes := Truncate (Remainder ( TotalSec,3600) / 60);
Totext ( Hours, '####') + ':'+
Totext ( Minutes,'00')
And my results show the 4 and the 28 in parentheses for being negative. Then I also did a highlight expert with if the results are < 0 to color red. 0 is coloring red and I didn’t set it up as < >= 0
( 4)28)
0:00
Any help you can give me will be greatly appreciated.
Thank you,
Angie Christman