| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding Up To Nearest Minute
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding Up To Nearest Minute
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding Up To Nearest Minute
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),"") "pinmaster" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding Up To Nearest Minute
....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),"") "daddylonglegs" wrote: 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),"") "pinmaster" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
| rounding to nearest hundred dollar in Excel | New Users to Excel | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Rounding up to the nearest nickel | Excel Discussion (Misc queries) | |||
| Rounding to nearest integer | Excel Worksheet Functions | |||
Linear Mode
