Weazel
Well-known Member
- Joined
- Dec 24, 2011
- Messages
- 3,155
In excel, when I have to round time to the nearest 30 minutes I can use =FLOOR([@Time],1/48), pretty straight forward.
I haven't been able to sort out the correct power query function though and I'm currently having to take care of it in the table.
Any assistance would be greatly appreciated
Unknown
<tbody>
</tbody>
<tbody>
</tbody>
I haven't been able to sort out the correct power query function though and I'm currently having to take care of it in the table.
Any assistance would be greatly appreciated
Unknown
Q | R | S | T | |
---|---|---|---|---|
1 | Time | DOW | Month | Interval |
2 | 8:17:00 AM | Wed | February | 8:00 |
3 | 8:37:00 AM | Wed | February | 8:30 |
4 | 9:07:00 AM | Wed | February | 9:00 |
5 | 9:34:00 AM | Wed | February | 9:30 |
6 | 9:56:00 AM | Wed | February | 9:30 |
7 | 10:27:00 AM | Wed | February | 10:00 |
<tbody>
</tbody>
Sheet2
Worksheet Formulas
<tbody> </tbody> |
<tbody>
</tbody>