ROUND({Time Tracking#Hours}*4,0)/4
The above formula is different than the other post in that this one rounds to the nearest quarter hour, as opposed to “rounding up” to the quarter hour.
Related Topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Time Tracking formula to round to quarter hour | 4 | 2462 | January 10, 2022 | |
| Automatically round 15 minutes to a time tracker | 1 | 576 | September 13, 2023 | |
| Can anyone tell me how to format time recorded in the time tracking column (eg 2h 55m) as a numer? | 6 | 2655 | February 22, 2023 | |
| Time remaining formula returning incorrect values where more than allocated time has been tracked | 6 | 1393 | August 25, 2022 | |
| Formula: Planned Hours minus Time Tracking | 1 | 3248 | June 21, 2021 |