Posted to microsoft.public.excel.misc

Fred Djinn Holstings Fred Djinn Holstings is offline

external usenet poster

Posts: 16

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rounding to the Nearest Eighth	L.sean9	Excel Discussion (Misc queries)	4	June 23rd 06 12:00 AM
rounding to nearest hundred dollar in Excel	Diane	New Users to Excel	7	October 14th 05 04:25 PM
Rounding numbers to the nearest 5 or 0	Fieldmedic	Excel Worksheet Functions	3	July 17th 05 06:51 AM
Rounding up to the nearest nickel	jhangas	Excel Discussion (Misc queries)	3	May 28th 05 12:41 AM
Rounding to nearest integer	pattyh	Excel Worksheet Functions	3	April 1st 05 08:02 PM

All times are GMT +1. The time now is 06:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us