Hi
You need, first of all, to understand how Excel stores time/date entries. Excel stores times and dates as an integer from 1 January 1900. So if you formatted a cell for example as days ("dd") and typed the figure 10 in that cell you would have 10/01/1900 in the formula bar.
Why do you want to format a cell with a format of minutes? If you explain why you need this we may be able to help you further.
Tony(OTPM)
|