Thread: [Solved] Cell formatting for time - Excel 2010
View Single Post
 
Old 09-05-2011, 02:19 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
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)
Reply With Quote