New time format

[Robert Crandal]

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

?????

Thank you!

 

[Rick Rothstein]

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.

 

[Robert Crandal]

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]

You didn't say that originally. Try this format instead...

[hh]:mm

 

[Robert Crandal]

I couldn't fine "[hh]:mm" in the custom format box. However,
I did find the following:

h:mm
[h]:mm:ss

The first format resets to 0 hours if the hours go above 24. I think
the other format does the same (and it also has the seconds appended
which I'm trying to eliminate).

I actually like the format in the "Time" section that is given
as:

"37:30:55"

The only problem is that the seconds are attached at the end. Can I
somehow tell excel not to display the last 3 charcters or hide
the colon and the last two seconds digits??

Thanks Rick

 

[Rick Rothstein]

You can add to the patterns in the Custom Format list (that is why it is
called "custom")... just click into the field under the word "Type" and
replace whatever is in there with a valid pattern of your own... such as the
[hh]:mm pattern I posted in my last message.

--
Rick (MVP - Excel)

I couldn't fine "[hh]:mm" in the custom format box. However,
I did find the following:

h:mm
[h]:mm:ss

The first format resets to 0 hours if the hours go above 24. I think
the other format does the same (and it also has the seconds appended
which I'm trying to eliminate).

I actually like the format in the "Time" section that is given
as:

"37:30:55"

The only problem is that the seconds are attached at the end. Can I
somehow tell excel not to display the last 3 charcters or hide
the colon and the last two seconds digits??

Thanks Rick

You didn't say that originally. Try this format instead...

[hh]:mm