Time Calc with rounding.

Kevin@Radstock · #1 06-26-2016, 01:59 PM

Hi

One way, wrap in IFERROR.

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

Kevin

billreed7 · #2 07-03-2016, 06:43 PM

Thanks for all your help on this have got it up and running now. thanks again. Billl

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