Roger Wrote:
On Mon, 20 Mar 2006 17:13:04 -0600, daddylonglegs
wrote:


Although 1:10 is, in fact hours and minutes you can still display as
70
by custom formatting as [m]


I appreciate the help guys, but I still can't get it.

I've fiddled with all the custom layouts, but nothing is working.

I'm open to any and all suggestions.

Thanks

use Format Cells Custom and type [m] in the box. Now if you enter
1:10 the cell will display 70 - no formula required! Although this is
technically minutes, not seconds, it works fine for display and if you
need to use the value for calculations any adjustment can take place in
the formula for that.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524578