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