Microsoft Office Forums - View Single Post - [Solved] Time calculations

Thread: [Solved] Time calculations

View Single Post

Old

12-10-2015, 10:01 AM

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

Assuming that the start time is in A1 and end time in B1:

=MOD(B1-A1,1) and format as "hh:mm" without the quotes.

Reply With Quote