Leading the way in Microsoft Office Development

Excel

Please contact us if you have any useful formulas we can add to this page.

To make a contribution to this website please e-mail us. feedback3@bettersolutions.com

1) Time - Displaying the Current Time

=A1-B1 = 10:52:37

=NOW()-TODAY() = 10:52:37

2) Calculate the time elapsed between 2 times

=MOD(A1-B1,1) = 21:36

=MOD(TIME(21,36,0)-TIME(3,0,0),1) = 21:36