How to add duration to time

Need help
1

I would like to have the user input (a) a start time for an event, and (b) a duration. I want a dynamic text field to then display the time that the event ends by adding (a) + (b). So if the user says an event starts at 7:00am and the duration is 1:30 then I want the dynamic text to add 7:00 + 1:30 and print out “8:30”. How do I do that? Sumproduct does not add time.

2

What data types are us using in (a) and (b)?

(a) = DATE
(b) =

I might be easier to split (b) into (b) hours and © minutes. That way you can use the +(hours) and +(seconds) to calculate the end time.

1 Like
3

This topic was automatically closed after 70 days. New replies are no longer allowed.