Hello All,
I am using CR 8.
I am trying to convert a number to a length of time, hh:mm:ss. The field I am trying to convert measures the length of a phone call. I am having difficulty with the formula to use. Each formula I have looked at wants to convert the number to an actual time.
The field is Duration and display the data in 100's of a minute, not 60's of a minute. I need to convert it to hh:mm:ss
Examples:
1.1 would eaqual 1:06 in minutes and seconds
8.8 would equaly 8:46 in minutes and seconds
What formula can I use?
Thanks for the help.
Helen Tip: Never fry bacon without a shirt on.
I am using CR 8.
I am trying to convert a number to a length of time, hh:mm:ss. The field I am trying to convert measures the length of a phone call. I am having difficulty with the formula to use. Each formula I have looked at wants to convert the number to an actual time.
The field is Duration and display the data in 100's of a minute, not 60's of a minute. I need to convert it to hh:mm:ss
Examples:
1.1 would eaqual 1:06 in minutes and seconds
8.8 would equaly 8:46 in minutes and seconds
What formula can I use?
Thanks for the help.
Helen Tip: Never fry bacon without a shirt on.