Rounding Up To Nearest Minute

[Guest]

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

 

[Guest]

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

 

[Guest]

Hello Fred,

Your formula can be simplified a little.....then you can add MROUND, i.e.

=IF(F2<>FALSE,MROUND(MOD(F2,1)-MOD(E2,1)+(NETWORKDAYS(E2,F2)-1)*"9:30",1/1440),"")

 

[Guest]

....orif you want to roundup just replace MROUND with CEILING, i.e.

=IF(F2<>FALSE,CEILING(MOD(F228,1)-MOD(E228,1)+(NETWORKDAYS(E228,F228)-1)*"9:30",1/1440),"")