Thread: Time Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default 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?