Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Good day! I have the following situation that I do not know how to address:
1-I have a column where the hours of entry are recorded called 'time entry'
2 - from the column of 'time entry' I want to create another column where I take the 'Time of entry' and group it in another column 'grouping Time' in the following way example:
-if 'time entry' is for example between 8:00 and 8:29 that brings me to the column 'group Time' 8:00
-if 'time entry' is for example between 8:30 and 9:00 that brings me to the column 'group Time' 9:00
-if 'time entry' is for example between 9:00 and 9:29 that brings me to the column 'group Time' 9:00
-if 'time entry' is for example between 9:30 and 10:00 that brings me to the column 'group Time' 10:00 and so on with the hours that I register in the column 'time entry'.
it is possible to create this condition in some way
It would help me a lot!!!!!
Solved! Go to Solution.
In that case divide the result of formula by 24 and change type to Time
Thank you very much for responding shortly!!!
I tell him that the solution works with the formula that I give myself, but I need to adjust it so that the time is displayed in this way hh:mm (example: 8:00) but it only shows me the Time in a single digit as shown in the attached image.
Hi,
try to use next formula for new calculated column:
Thank you very much for responding shortly!!!
I tell him that the solution works with the formula that I give myself, but I need to adjust it so that the time is displayed in this way hh:mm (example: 8:00) but it only shows me the Time in a single digit as shown in the attached image.
In that case divide the result of formula by 24 and change type to Time
Thankful! your response to worked wonders!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |