Looking for a worklfow that can find Start time, End time, and Duration from present value

Question

So we have to deal with class attendance for work training a lot and often time the attendance reports that are sent to us are for some reason missing information(even though they are all the same blasted report)

There will be a column For Start time, End time and Duration.

Start time and end time is always in this format:  11/4/2020 4:01:45 PM
The format for duration is always:  00:02:59

I want to come up with a workflow(well more like multiple work flows in one) That can find the missing value from the present values
So End time would be Start time plus Duration
Duration would be End time Minus Start time
Start time would be End time Minus Duration.

Is this something that can be done in Alteryx.

Qiu · Answer

@rmartori 
@NicoleJohnson did a good one, but I can not say it is a little Formula...😁

New Workflow2.yxmd

NicoleJohnson · Answer

It is absolutely possible!... with a little DateTime formula trickery. See attached for example, but the general gist of the formulas used is that, when in the right format, you can add or subtract duration to derive the Start & End dates, and you can calculate the time between Start & End dates, all using various DateTime formulas!

Example of Start & End Time calculations:

Example of Duration (had to use a few extra formulas to get the time in the right format):

If you want to dig into the DateTime formulas more, check out this helpful link!

Hope this helps! Cheers,

NJ

DateTime Calculations.yxmd