| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell format
How do I change a cell whose content is hh:mm:ss and the value might be
267:45:00 to a format that displays the days:hours:minutes? Is this possibe? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell format
Hi,
Did you try dd:hh:mm:ss Mike "pjr57" wrote: How do I change a cell whose content is hh:mm:ss and the value might be 267:45:00 to a format that displays the days:hours:minutes? Is this possibe? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell format
Use a custom format (FormatCellsCustom) of 'd "days" h:mm' without the
single quotes. -- __________________________________ HTH Bob "pjr57" wrote in message ... How do I change a cell whose content is hh:mm:ss and the value might be 267:45:00 to a format that displays the days:hours:minutes? Is this possibe? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell format
OK until it goes beyond 31 days.
-- David Biddulph "Mike H" wrote in message ... Hi, Did you try dd:hh:mm:ss Mike "pjr57" wrote: How do I change a cell whose content is hh:mm:ss and the value might be 267:45:00 to a format that displays the days:hours:minutes? Is this possibe? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell format
OK until it goes beyond 31 days.
-- David Biddulph "Bob Phillips" wrote in message ... Use a custom format (FormatCellsCustom) of 'd "days" h:mm' without the single quotes. -- __________________________________ HTH Bob "pjr57" wrote in message ... How do I change a cell whose content is hh:mm:ss and the value might be 267:45:00 to a format that displays the days:hours:minutes? Is this possibe? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Linear Mode
