Forum Discussion
SkorpionAAM
Helper V
Helper VAdd 10 hours in TIME Data with Condition
I have data like this 12:00 Am 2:00 Am 8:00 Am and so on what i need on these timing that 10:00 Am is this realy opeing timing of work so if time start from 00:00:00 to 9:00...
Then use the IF statement to check it is between the time period, modify the table/column name accordingly
Column = FORMAT ( IF([Column1]>=TIME(0,0,0)&&[Column1]<=TIME(10,0,0),TIME(10,0,0),[Column1]),"hh:mm:ss AM/PM" )
SkorpionAAMHelper V
Helper Vonly for the time between 0am to 10am should be converted to 10am
Then use the IF statement to check it is between the time period, modify the table/column name accordingly
Column =
FORMAT ( IF([Column1]>=TIME(0,0,0)&&[Column1]<=TIME(10,0,0),TIME(10,0,0),[Column1]),"hh:mm:ss AM/PM" )