Forum Discussion

MrTechie's avatar
MrTechie
Frequent Visitor
2 years ago
Solved

Incremental Minutes for each row in Power Query

Hi, I am trying to add an incremental 5 minutes to each row in the power query.

Please see the data and expected output below:

Date TimeOutput
16/12/2023 8:35:00 PM +10:0016/12/2023 8:35:00 PM +10:00
16/12/2023 8:35:00 PM +10:0016/12/2023 8:40:00 PM +10:00
16/12/2023 8:35:00 PM +10:0016/12/2023 8:45:00 PM +10:00
16/12/2023 8:35:00 PM +10:0016/12/2023 8:50:00 PM +10:00
17/12/2023 12:15:00 PM +10:0017/12/2023 12:15:00 PM +10:00
17/12/2023 12:15:00 PM +10:0017/12/2023 12:20:00 PM +10:00
17/12/2023 12:15:00 PM +10:0017/12/2023 12:25:00 PM +10:00

 

TIA

Need Help

5 Replies

    • MrTechie's avatar
      MrTechie
      Frequent Visitor
      2 years ago

      Ahmedx thank you for your replay,

      but the expected output is a bit different. 

      for example, if the data for the day starts with 

      Row 1  -- 16/12/2023 8:35:00 PM

      Row 2  -- 16/12/2023 8:40:00 PM

      Row 3  -- 16/12/2023 8:45:00 PM

      Row 4  -- 16/12/2023 8:50:00 PM