Forum Discussion

bhaskarpbi999's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
2 years ago

Create ID for each weekday time1 and time2 based on the sample data

Hi ,   I need some help as the ID is working for all weekdays but not for friday.     Sample data google drive link https://docs.google.com/spreadsheets/d/1kMgzehh1inILMJ7VA-EuHR36vsv53Jc...
Need Help
bhaskarpbi999's avatar
bhaskarpbi999
Icon for Helper V rankHelper V
2 years ago

Hi Dufo,

Current source data has 3 columns Index, Date, time like below

 

 

Expected output is 4th custom column ID need to created and time1 and time 2 values needed for each weekday.

 

 

Attaching source sample data with below link and sorry for the trouble caused by me.

 

Sample Data