changing time from hh:mm to hhmm
I need to create a calculation field that converts a field that has been formatted for time as hh:mm needed for another calculation to hhmm.
If you mean you want a TEXT result formatted as hhmm, try:
SerialIncrement ( "0000" ; 100 * Hour ( Timefield ) + Minute ( Timefield ) )
As already mentioned, any formatting applied to Timefield on a layout is irrelevant here. You can even place another instance of the field on the layout and format it as hhmm.
Retrieving data ...