How to i display 15 as 15 mins without showing the date (EXCEL)

  • Thread starter Thread starter Jonathan
  • Start date Start date
J

Jonathan

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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top