how to calculate average time

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

02-17-2017, 04:18 PM

aymanharake aymanharake is offline

Mac OS X

Office 2016

Novice

Join Date: Feb 2017

Posts: 6

Quote:

Originally Posted by jeffreybrown

In D2, try this formula instead...

=MOD(C2-B2,1)

...can copy down

That worked perfectly. thank you very much!

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 08:09 PM.