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:59 PM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 10

Windows 10 Kevin@Radstock uses Office 2016

Kevin@Radstock uses Office 2016

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

Hi

One way, wrap in IFERROR.

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

Kevin

Reply With Quote