As Daddylonglegs said use custom format and type in [hh]:mm or select the
built in format, then click custom and click at the end in the format box
and backspace off the :ss at the end

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

Portland, Oregon




"oxicottin" wrote
in message ...

Oh I see!! Im using =SUM(K6:L20) to get a total time and then I go to
the box and select FormatCellsCustom[h]:mm ? It worked but I cant
find or dont have a [h]:mm I have a [h]:mm:ss which gives seconds and I
dont want seconds. Where is the other one located (microsoft
2003)Thanks!!


--
oxicottin
------------------------------------------------------------------------
oxicottin's Profile:
http://www.excelforum.com/member.php...o&userid=31702
View this thread: http://www.excelforum.com/showthread...hreadid=514055