Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New time format
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New time format
You didn't say that originally. Try this format instead...
[hh]:mm -- Rick (MVP - Excel) "Robert Crandal" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
New time format
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" wrote in message ... You didn't say that originally. Try this format instead... [hh]:mm -- Rick (MVP - Excel) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
New time format
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) "Robert Crandal" wrote in message ... 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" wrote in message ... You didn't say that originally. Try this format instead... [hh]:mm -- Rick (MVP - Excel) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |