Thread
:
Time Format
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Bob
external usenet poster
Posts: 972
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?
Reply With Quote
Bob
View Public Profile
Find all posts by Bob