Hi,

One way:

=CEILING((F228<FALSE,(9.5+(MOD(F228,1)-MOD(E228,1))*24+(NETWORKDAYS(E228,F228)-2)*9.5)/24,""),TIME(0,1,0))

HTH
Jean-Guy

"Fred "Djinn" Holstings" wrote:

How would I get the below formula to round up to the nearest minute?

=IF(F228<FALSE,(9.5+(MOD(F228,1)-MOD(E228,1))*24+(NETWORKDAYS(E228,F228)-2)*9.5)/24,"")

Thanks Much!
Fred