Microsoft Office Forums - View Single Post - [Solved] Time Calc with rounding.

Thread: [Solved] Time Calc with rounding.

View Single Post

Old

06-26-2016, 01:37 PM

billreed7

billreed7 is offline

billreed7 uses Windows 10

Windows 10 billreed7 uses Office 2010 64bit

billreed7 uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Jun 2016

Posts: 3

billreed7 is on a distinguished road

Default

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

Reply With Quote