Microsoft Office Forums - View Single Post - [Solved] how to calculate average time

Thread: [Solved] how to calculate average time

View Single Post

Old

02-16-2017, 05:29 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

In D2, try this formula instead...

=MOD(C2-B2,1)

...can copy down

Reply With Quote