Hi Group,
I have the following formula for one of my date/time field.
However if the source is 34:53, I get 34:32.
If the source is 21:58, I get 21:35 and for 33:25 I get 33:15.
What's wrong with this formula?

If{tblTimecard.STDmins} > 0 then
ToText ({tblTimecard.STDhrs},0) + ":" + ToText ({tblTimecard.STDmins},00)
else
ToText ({tblTimecard.STDhrs},0) + ":00"

I'm using version 6.5. If I use & instead of +, I get the following error: Remaining text does not appear to be part of the formula.


Kind Regards