D
DocBrown
I want to create a text box where the user enters hours and minues as hh:mm,
where hours could be more than 24 hours. I want to convert that value to
minutes before saving it in my table. Is there a function that will do that
or do I need to parse the string myself and convert this to minutes?
Eventually, when the records are retrived, I will be summing the minutes
from records obtained from a query and then I will covert the minutes to
hhh:mm for display in another text box on a form.
Any tips on the way to do this is appreciated.
Thanks,
John
where hours could be more than 24 hours. I want to convert that value to
minutes before saving it in my table. Is there a function that will do that
or do I need to parse the string myself and convert this to minutes?
Eventually, when the records are retrived, I will be summing the minutes
from records obtained from a query and then I will covert the minutes to
hhh:mm for display in another text box on a form.
Any tips on the way to do this is appreciated.
Thanks,
John