| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Time in Excel
I would like to display time in minutes and seconds only even if over
an hour. If the amount of time is 65 minutes I would like it displayed as 65:00 not 1:05:00. Is this possible in excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Time in Excel
One way:
Format/Cells/Number/Custom [m]:ss In article .com, "gfkbob" wrote: I would like to display time in minutes and seconds only even if over an hour. If the amount of time is 65 minutes I would like it displayed as 65:00 not 1:05:00. Is this possible in excel? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Time in Excel
On Mar 29, 8:23 pm, JE McGimpsey wrote:
One way: Format/Cells/Number/Custom [m]:ss In article .com, "gfkbob" wrote: I would like to display time in minutes and seconds only even if over an hour. If the amount of time is 65 minutes I would like it displayed as 65:00 not 1:05:00. Is this possible in excel?- Hide quoted text - - Show quoted text - I am using ms office 2003. I don't see the entry you are speaking of. I see mm:ss but that doesnot work. it shows 65:00 as 5:00. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Time in Excel
You need to enter the string
[m]:ss in the inputbox in the dialog. After that, it will appear in the listbox below the input box. In article .com, "gfkbob" wrote: On Mar 29, 8:23 pm, JE McGimpsey wrote: One way: Format/Cells/Number/Custom [m]:ss In article .com, "gfkbob" wrote: I would like to display time in minutes and seconds only even if over an hour. If the amount of time is 65 minutes I would like it displayed as 65:00 not 1:05:00. Is this possible in excel?- Hide quoted text - - Show quoted text - I am using ms office 2003. I don't see the entry you are speaking of. I see mm:ss but that doesnot work. it shows 65:00 as 5:00. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying negative time in excel | Excel Worksheet Functions | |||
| Displaying time from 00:00 to 0.00 | New Users to Excel | |||
| Displaying Unix time as date and time | Excel Discussion (Misc queries) | |||
| I displaying a range in Time within a cell in Excel. | Excel Discussion (Misc queries) | |||
| Time displaying wrongly | Excel Discussion (Misc queries) | |||
![gfkbob[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
