Need to convert string field to time field

[jeffm777]

I have a duration string field that shows:
"3 Hr, 27 Min" or "20 Min".

I need a formula to convert this field to a field that will show "03:05" for 3 Hr, 5 Min or "00:20" for 20 Min.

I need to do an average sum on this field so I can show an average duration.

 

[FireGeek21]

Question first, if you ever just have Min (no Hr) will the number of Min ever be > 59? Example, will you ever see 90 Min or will it always be presented as 1 Hr, 30 Min?

RSGeek


RSGeek
(currently using Crystal Reports XI with Lawson 8.03)

 

[jeffm777]

No. If the Min is > 59, it will roll over to show 1 Hr, 0 Min.