StrBody display entered info as hours

I have created a form that, when data is entered, will email content to select indiviuals.  2 of the items are entered in HH:MM format, but when the email is sent they appear as a decimal.  Can anyone assist to make these decimal formatted items display as HH:MM in the email body:  Here is what I currently have:

StrBody = “Date    ” & e.Cells(row, “a”) & “<br>” & _

              “Shift   ” & e.Cells(row, “b”) & “<br>” & _

              “Re-Work Reason:    ” & e.Cells(row, “c”) & “<br>” & _

              “Trip #:   ” & e.Cells(row, “d”) & “<br>” & _

              “Delivery #(s):   ” & e.Cells(row, “e”) & “<br>” & _

              “Sales Order#(s):   ” & e.Cells(row, “f”) & “<br>” & _

              “Appt Time:   ” & e.Cells(row, “g”) & “<br>” & _

              “# of Coils:   ” & e.Cells(row, “h”) & “<br>” & _

              “Re-Work Location:   ” & e.Cells(row, “i”) & “<br>” & _

              “Time Taken to Processing:   ” & e.Cells(row, “j”) & “<br>” & _

              “Employee name who delivered to processing:   ” & e.Cells(row, “k”) & “<br>” & _

              “Contacted Supervisors:   ” & e.Cells(row, “l”) & “<br>” & _

              “Comments:   ” & e.Cells(row, “m”) & “<br>” & _

By: R. Lush

Leave a Reply

Your email address will not be published. Required fields are marked *