Condition Row Insert

[mroker]

hello! I am having a problem with trying to create a row based on a condition and hoping someone can help me.

id	DateTime	TimeSlot	Seconds
54	10:01	10:00	4200
65	10:35	10:30	3
67	11:06	11:00	98

In the above table, I want to create a row for every time more than 1 hour. For example, id 54 has 4200 seconds so another row should be created with the same id in the 10:30 timeslot and the seconds subtracted.

id	DateTime	TimeSlot	Seconds
54	10:01	10:00	4200
54	10:31	10:30	600
65	10:35	10:30	3

[Qiu · Accepted solution]

@mroker 
Hope this is what you need.

If you do, appreciate if you would mark it as acceptable.

[RobertOdera · Accepted solution]

Hi, @mroker 

Looking at your question below, I also wonder whether:

• you need to adjust DateTime and TimeSlot (to account for the additional hour block of elapsed time within the same ID)
• you need to adjust for Seconds (since every hour block of elapsed time within the same ID, except the last one, is 3600 seconds)

If you've answered yes to the above, then kindly consider the approach below.

Please like + mark as an acceptable solution, if this works for you.

The workflow is attached.

Cheers!

[RobertOdera]

Thanks for your favorable response @mroker 

Please let me know if you need anything else. Cheers!