Thread: Cell with hours
View Single Post
 
Old 02-11-2011, 06:19 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
Hi
Quote:
Originally Posted by meninio View Post
Ex: I need to insert the value of 30 hours. When I enter 30:00, it gets reset and the year appears more 00:00:00.
Please can you explain more on what this means? Feel free to attach an example if it would help.

Does the format [hh]:mm not work for you?
Reply With Quote