Thread: [Solved] how to calculate average time
View Single Post
 
Old 02-17-2017, 04:18 PM
aymanharake aymanharake is offline Mac OS X Office 2016
Novice
  
Join Date: Feb 2017
Posts: 6
aymanharake is on a distinguished road
Default
Quote:
Originally Posted by jeffreybrown View Post
In D2, try this formula instead...

=MOD(C2-B2,1)

...can copy down
That worked perfectly. thank you very much!
Reply With Quote