Time Calc with rounding.

		Microsoft Office Forums > Microsoft Excel > Excel
Time Calc with rounding.

06-26-2016, 01:59 PM

Kevin@Radstock Kevin@Radstock is offline

Windows 10 Time Calc with rounding.

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

Hi

One way, wrap in IFERROR.

=IFERROR(MROUND(MOD((--REPLACE(C1,3,0,":"))-(REPLACE(B1,3,0,":")),1),"00:15")*24,"")

Kevin

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rounding Up or Down depending on Start & End time	richardst	Excel	4	06-21-2016 06:03 PM
Rounding to nearest 0.25	Guloluseus	Excel	5	10-27-2015 11:28 PM
Trying to create a formula to calc if I add x new accounts, I will have to hire y tech/support ppl	glen123	Excel	7	07-28-2014 07:29 AM
XML List of lists in Excel or Calc	manofspider	Excel	1	08-05-2011 09:03 AM
Creating an Auto-Calc'd Date? Today+7 Days?	SoCalTelephone	Word	0	10-06-2010 10:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:01 PM.