| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Format
Format Cell Number Custom [mm]:ss
-- Gary''s Student - gsnu200759 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Format
Many thanks!
"Gary''s Student" wrote: Format Cell Number Custom [mm]:ss -- Gary''s Student - gsnu200759 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a time format to a String format in Excel | Excel Discussion (Misc queries) | |||
| Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
| How to format cells in Excel for time in format mm:ss.00 | Excel Worksheet Functions | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Linear Mode
