InfoPath Dev

 My apologies, the result is in minutes & I need to know how do I convert this into hrs and minutes? any help is appreciated.

 Hi, How do I convert whole number to Time?  E.g. I have Time1: 01:20:00 & Time2: 01:25:00 The result should be: 00:05:00 I used this formula to get Total minutes= 60 * (substring(Later Time, 12, 2) - substring(Earlier Time, 12, 2)) + (substring(Later Time, 15, 2) - substring(Earlier Time, 15, 2)) + (substring(Later Time, 18, 2) ...