Thread: Help plz
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chad chad is offline
external usenet poster
 
Posts: 273
Default Help plz

Here is my exact formula as typed right now:

=IF(ISBLANK(OFFSET('Agent Performance Rankings'!U1,1,0,)),"
",IF(ISERROR(OFFSET('Agent Performance Rankings'!U1,1,0,))," ",OFFSET('Agent
Performance Rankings'!U1,1,0,)))

The cell it references vaule is 2041.4667.
I want it to take that vaule which is a number of seconds and display it in
MM:SS format but it not working right for me.