Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |