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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to i display 15 as 15 mins without showing the date (EXCEL)
Entering 00:15 into a cell stores the value as 15 minutes and autoformat the
cell to hh:mm format. Check out the below link to see how excel stores date and time. http://www.cpearson.com/excel/datetime.htm If this post helps click Yes --------------- Jacob Skaria "Jonathan" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to i display 15 as 15 mins without showing the date (EXCEL)
Jonathan...
I tried a custom format but nothing worked for me. I can only find this way to make it work for you... #.15 You need to set up a column before or after your data area. Format the col text to white so its not seen, and col width to be small and thin. (This will be your data entry location) "Col B" A B 4line .15 15 <--- not seen (format col. for "White" text) (Data Entry B4) In cell A4 use this =b4/100 (OR) =IF(B4="","",B4/100) ... if you will be Conditional Formating the cell. For 1 hour & 15 minutes (enter 115) it will be 1.15 I hope this helps you... "Jonathan" wrote: 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 |
Reply |
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 |