View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default IF Statement (Nested IF's??)

Do you mean you want it to show 0:20:30 ? If so, just format the cell
(highlight all the cells first if there are many of them) using Format
| Cell | Number (tab) and select Time and choose 37:30:55 from the list
- this is effectively the same as [h]:mm:ss.

Hope this helps.

Pete