I have a design question, need input and help with.
I have 3 columns Time In, Duration, Time Out Time In is Time() Duration is a dropdown consisting of the following: 0:05 0:10 0:15…and so on. At the moment it’s text based, only because I want to display it in that format for the end user, it’s not entirely important. Time Out is the sum of Time In + Duration, i.e. 10:15 AM + 0:15 = 10:30 AM.
Can I still use a text based input to get my result? Or if not, how can I display it in a similar way and get the same result? Or, am I approaching this entirely wrong? Which is most likely the case ;).