C
Chad
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.
=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.