Actually, you'll have to use a calculation to convert the decimal to minutes. Here's an example of what this might look like.
NumberVar Hours := 0;
NumberVar Minutes := 0;
If not IsNull({MyTable.Time}) then
(
Hours := {MyTable.Time} \ 1;
Minutes := ({MyTable.Time} - Hours) * 60;
);
ToText(Hours, 0, "") + ":" + ToText(Minutes, 0, "")
Note the use of the backslash "\" in the Hours calculation. This is "Integer Divide" which will just give you the integer portion of the calculation without the numbers after the decimal.
If you need this to be an actual Time value as opposed to just text for display, change the final part of the formula to:
Time(Hours, Minutes, 0,)
NOTE: When working with variables, you'll need to use ":=" for assignment where you would use just "=" in formulas without a variable. Also, note where I've put the semi-colons, they're important for getting this to process correctly. DO NOT put a semi-colon at the end of the last line or else the value won't display on the report.
-Dell
IP Logged
