Thread: Cell with hours
View Single Post
 
Old 02-11-2011, 05:09 AM
meninio's Avatar
meninio meninio is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Jan 2011
Location: Brasil
Posts: 15
meninio is on a distinguished road
Default Cell with hours

Good morning,

Must enter a cell only the amount of hours that the category does not have the hours to put the full amount.

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.

Does anyone know how to format the value to appear only 30:00?
Reply With Quote