Skip to Content
0
Former Member
Jul 03, 2009 at 12:38 PM

Converting a duration field into Hours and mins

658 Views

Hi

I have a duration field which is actually a string. it's in the format HH:MM:SS

I want to convert it to a formula field and then show the total duration at the top of the report.

At first I tried CTime but quickly realised this just converted to a time.

Can anyone help as I am a bit stuck

thanks alot