Cell formatting for time - Excel 2010

[PomDave]

Hi All,

I cannot seem to get the formatting of time correct in my spreadsheet.

I try to set the cell format to 'mm' for minutes only but everytime I place a figure like 20, into the cell I get '01' showing in the cell and 20/01/1900 showing in the formula bar.

No matter how I try to put a figure into the cell it just will not show up correctly, subsequently, I cannot get the right answers when adding minute together.

Can Excel perform this type of operation or is it just for show.



Best Rgds
Dave R