| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to i display 15 as 15 mins without showing the date (EXCEL)
I want to type 15 into the box so that it displays as 00: (15 mins) I thought
I had found a way but it insits on including the date which is irrelevant or turning the figure into days |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date showing incorrect. 30:00 hrs showing 06:00 | Excel Discussion (Misc queries) | |||
| how can i convert a value quoted in hrs,mins,secs to just mins | Excel Worksheet Functions | |||
| Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
| How to convert numeric value to mins and addimg mins to Hrs. | Excel Worksheet Functions | |||
| Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Threaded Mode
