Hey all,
I have a web page that queries our SQL database and have created a function that returns the value as a double which represents the number of logged hours.
If the user has enough hours then he can access the download button. If not, then I have a label that appears stating You need at least 20 flight hours and you currently have xx hours.
Everything is working properly, except that the amount of hours appearing in the label is 19.4535235. I would like to convert this value to hh:mm, so in other words, You need at least 20 flight hours and you currently have 19:27 hours.
Here is the code to clarify:
doubleTotalHours = functionCalculateTotalHours()
Select Case doubleTotalHours
Case Is >= 20
TableDownload.Visible = True
Case Else
LabelMembersOnly.Text = "Sorry, ...
Go to the complete details ...