| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I CONVERT 12:00:00 to show as o hrs
i have a start time in hrs and mins 12:00:00
how can this show up as 00:00 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I CONVERT 12:00:00 to show as o hrs
If you want it to show as 00:00 you could subtract 12 hours, and then format
as hh:mm If, however, you format the cell as mm:ss you don't need to subtract the 12 hours. -- David Biddulph "Trevor" wrote in message ... i have a start time in hrs and mins 12:00:00 how can this show up as 00:00 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I CONVERT 12:00:00 to show as o hrs
Thanks for the reply
much appreciated "David Biddulph" wrote: If you want it to show as 00:00 you could subtract 12 hours, and then format as hh:mm If, however, you format the cell as mm:ss you don't need to subtract the 12 hours. -- David Biddulph "Trevor" wrote in message ... i have a start time in hrs and mins 12:00:00 how can this show up as 00:00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
| How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
| FILTER: show/don't show selection with tickboxes | Excel Discussion (Misc queries) | |||
| with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) | |||
| How do I convert 300616a to show as a number 303616? | Excel Worksheet Functions | |||
Linear Mode
