how to calculate average time

		Microsoft Office Forums > Microsoft Excel > Excel
how to calculate average time

02-16-2017, 05:29 PM

jeffreybrown jeffreybrown is offline

Windows Vista how to calculate average time

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

In D2, try this formula instead...

=MOD(C2-B2,1)

...can copy down

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to calculate weighted average in table?	alexsimpson	Word Tables	3	12-01-2016 03:19 PM
dynamic ranges to calculate average	teatree	Excel	1	11-11-2016 10:11 AM
dynamic ranges to calculate average	teatree	Excel	1	11-11-2016 10:03 AM
Calculate average age	FTL	Excel	1	08-09-2016 06:56 AM
Calculate Average Time Elapsed in Days, hours and minutes	Nina46	Excel	9	09-11-2015 02:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:12 AM.