|
|
#1
02-11-2011, 05:09 AM
|
||||
|
||||
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? 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Actual working hours per day | climbatron | Project | 2 | 12-17-2015 03:13 PM |
| Help on the formulate hours | meninio | Excel | 2 | 02-11-2011 04:56 AM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
| How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Windows XP 
Office 2010 32bit
Threaded Mode