Time Format
 

An equation...

=SUM(IF($B9='Lineup Worksheet'!$B$2:$B$83,'Lineup Worksheet'!$C$2:$C$83,0))

produces the correct answer of 1:04:21. But I want the answer to be
displayed only in minutes:seconds, as 64:21. Any idea of how to do this?

Time Format
 

Format Cell Number Custom [mm]:ss
--
Gary''s Student - gsnu200759

Time Format
 

Many thanks!

"Gary''s Student" wrote:

Format Cell Number Custom [mm]:ss
--
Gary''s Student - gsnu200759

Time Format
 

any time!
--
Gary''s Student - gsnu200759


"bob" wrote:

Many thanks!

"Gary''s Student" wrote:

Format Cell Number Custom [mm]:ss
--
Gary''s Student - gsnu200759

Time Format
 

Note: you could use SUMIF to make this a non-CSE formula, i.e.

=SUMIF('Lineup Worksheet'!$B$2:$B$83,$B9,'Lineup Worksheet'!$C$2:$C$83)

"Gary''s Student" wrote:

any time!
--
Gary''s Student - gsnu200759


"bob" wrote:

Many thanks!

"Gary''s Student" wrote:

Format Cell Number Custom [mm]:ss
--
Gary''s Student - gsnu200759