View Single Post
Old 09-03-2011, 07:34 PM
PomDave PomDave is offline Windows Vista Office 2010 32bit
Advanced Beginner
Join Date: Sep 2011
Location: Australia
Posts: 30
PomDave is on a distinguished road
Default Cell formatting for time - Excel 2010

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
Reply With Quote