Challenge summing time (mm:ss) values?

		Microsoft Office Forums > Microsoft Excel > Excel
Challenge summing time (mm:ss) values?

FAQ

Thread Tools

Display Modes

12-17-2014, 10:41 AM

Pecoflyer

Windows 7 64bit Challenge summing time (mm:ss) values?

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Another method . Use following formula

Code:

=sumproduct(B2:B113*1)/60

and custom format the result as [h]:mm:ss

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Summing up values in a Single Merge Field	Beowolf	Mail Merge	1	03-07-2014 03:26 PM
MATCH function and time values	hanvyj	Excel	2	05-29-2013 12:12 PM
Challenge for a genius ?	e.roberts	Office	3	07-13-2012 01:36 AM
Formatting Merged Time Values Between Excel & Word	JennEx	Mail Merge	1	07-12-2012 02:54 PM
Word Challenge	jpotter2	Word	3	03-22-2011 02:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:16 PM.