what is the formula for rounding time up to 1/4 hr?
 

Does anyone know the formula for rounding up time to the next 1/4 increment?

what is the formula for rounding time up to 1/4 hr?
 

The following formula will do what you asked...

=IF(MOD(A4,TIME(0,15,0))=0,A4,MROUND(A4+TIME(0,7,0 ),TIME(0,15,0)))

It requires the Analysis ToolPak Add-in to be selected in the Tools/Add-Ins
option on Excel's menu bar.

Rick


"Rosemary" wrote in message
...
Does anyone know the formula for rounding up time to the next 1/4
increment?

what is the formula for rounding time up to 1/4 hr?
 

Just occurred to me... if your time values can have seconds in them, then
use this formula instead,

=IF(MOD(A4,TIME(0,15,0))=0,A4,MROUND(A4+TIME(0,7,2 9),TIME(0,15,0)))

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
The following formula will do what you asked...

=IF(MOD(A4,TIME(0,15,0))=0,A4,MROUND(A4+TIME(0,7,0 ),TIME(0,15,0)))

It requires the Analysis ToolPak Add-in to be selected in the
Tools/Add-Ins option on Excel's menu bar.

Rick


"Rosemary" wrote in message
...
Does anyone know the formula for rounding up time to the next 1/4
increment?

what is the formula for rounding time up to 1/4 hr?
 

=CEILING(A1,1/96)
--
David Biddulph

"Rosemary" wrote in message
...
Does anyone know the formula for rounding up time to the next 1/4
increment?

what is the formula for rounding time up to 1/4 hr?
 

And, of course, David's formula is far superior. You may want to use his
formula this way, though....

=CEILING(A1,TIME(0,15,0))

as it will be easier to modify the round-off time (for example, to next 30
minute increment) in the future.

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
Just occurred to me... if your time values can have seconds in them, then
use this formula instead,

=IF(MOD(A4,TIME(0,15,0))=0,A4,MROUND(A4+TIME(0,7,2 9),TIME(0,15,0)))

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
The following formula will do what you asked...

=IF(MOD(A4,TIME(0,15,0))=0,A4,MROUND(A4+TIME(0,7,0 ),TIME(0,15,0)))

It requires the Analysis ToolPak Add-in to be selected in the
Tools/Add-Ins option on Excel's menu bar.

Rick


"Rosemary" wrote in message
...
Does anyone know the formula for rounding up time to the next 1/4
increment?

what is the formula for rounding time up to 1/4 hr?
 

=ROUNDUP(A1*96,0)/96


"Rosemary" wrote:

Does anyone know the formula for rounding up time to the next 1/4 increment?