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!

[Suvrutt_Gurjar]

One cannot add "time to time" because time is an instantaneous value. However one can definitely add duration ( [Estimated Time])  to time ([Start Time])  in your example which I believe is what you are looking for.

So please try an expression something like 

[Start Time] +(TIME(CONCATENATE(0&(FLOOR([Estimated Time])),":", (([Estimated Time]-FLOOR( [Estimated Time]))*60)))-"00:00")

I believe there should definitely be an easier / simpler expression, but the above should at least work.

Assumes [Start Time] is a time type column and [Estimated Time] is a decimal column with one decimal digit.