I have something similar to this but in my case this will not work. I have a text field storing the value in mins in this format 000100 representing 1 min.
I need to break this into a time reference 00:01:00 so that I can use it to calculate total time spent.
I have tried several different date/time functions but they all add the date, which I do not need.
question is: is there a way to convert this text into a time only field ?
TimeSpan object.
(Note: They inter-twine very well with the DateTime object)
But you should be able to create a timespan object from a number of secods or minutes, or whatever
Comment