GETHHMM – Convert minutes to hours and minutes This function converts a number of minutes into the HHMM format. GETHHMM(<minutes>) Where <minutes> is the number of minutes to convert. For example, GETHHMM(72) returns 0112.