|
|
#4
06-26-2016, 01:37 PM
|
|||
|
|||
Thanks Kevin
That works a treat, but how do you get the #Value! to disappear in the answer cell? when there is nothing in B1 and C1.
I am using =MROUND(MOD((--REPLACE(C1,3,0,":"))-(REPLACE(B1,3,0,":")),1),"00:15")*24 
|
|
|
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 |
Windows 10 
Office 2010 64bit
Threaded Mode