I'm trying to round to the nearest quarter hour but if the rounding is less than 1:15 I want the cell to just display 1:15
I've tried =IF(CEILING((B2-A2),"00:15")<"01:15","1:15",CEILING((B2-A2),"00:15")) and it just puts 1:15 is every cell no matter if it's above or below 1:15
Below is an example. I only want the second column of time to be displayed. I'm displaying the first column of time for reference of the actual time.
The rounding is correct except for I do not want 1:15 to round up to 1:30.
Any help would be appreciated.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I've tried =IF(CEILING((B2-A2),"00:15")<"01:15","1:15",CEILING((B2-A2),"00:15")) and it just puts 1:15 is every cell no matter if it's above or below 1:15
Below is an example. I only want the second column of time to be displayed. I'm displaying the first column of time for reference of the actual time.
The rounding is correct except for I do not want 1:15 to round up to 1:30.
Any help would be appreciated.
3/1/2019 10:40 | 3/1/2019 11:50 | 1:10 | 1:15 |
3/1/2019 3:30 | 3/1/2019 5:20 | 1:50 | 2:00 |
3/1/2019 13:05 | 3/1/2019 13:30 | 0:25 | 1:15 |
3/2/2019 7:40 | 3/2/2019 8:55 | 1:15 | 1:30 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>