How to add time to time?

[himan]

Hi Everyone,

I have a column [Start Time] which is of type "Time" and is calculated using the TIMENOW() function.

I also have a virtual column [Estimated Hours] (decimal) that calculates the required time based on simple divisions and basically returns values like 1.5, 1.4, etc. - which are just hours I want to add.

I’m trying to add these [Estimated Hours] to [Start Time] to calculate [Estimated Time], but I’m running into some issues. Specifically, I’ve seen in similar posts that I might need to format the time in a way like "000:00:00", but this approach seems too static for my use case as I need to dynamically pass [Estimated Time] values.

Does anyone know the best way to achieve this? Any advice would be greatly appreciated!

Thank you in advance!