Hi Rick,

That format works fine, but it doesnt work for cases when
the there are more than 24 hours. Some of my time
data examples will be 44:11 (44 hours, 11 minutes) or
even 200:35 (200 hours, 35 minutes).

I guess I'm not really looking for times on a clock,
but rather time durations expressed as hours and minutes only
(with no trailing seconds).

Is there anything else I can do??

thank u


"Rick Rothstein" wrote in message
...
Custom format the cell with exactly what you wrote... the seconds will
still be there (because it is a format), they just won't display in the
cell.

--
Rick (MVP - Excel)


"Robert Crandal" wrote in message
...
I want to use Excel's "hh:mm:ss" format in my cells, but I want to
remove the seconds ("ss") part. Is there a way that I can configure
a cell to just display a time format as follows? :

hh:mm