I have a requirement to add a certain amount of hours to a time field based on the value in another field.
example: if value in field A = 1, then add 4 hours to time field
if value in field A = 2, then add 8 hours to time field
Please let me know if this achievable in metabase. if yes, then how should I proceed.