Cell with hours

meninio · #1 02-11-2011, 05:09 AM

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?

Colin Legg · #2 02-11-2011, 06:19 AM

Hi

Quote:

Originally Posted by meninio

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?

meninio · #3 02-11-2011, 06:28 AM

Quote:

Originally Posted by Colin Legg

Hi

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?

When I use the [hh]: mm format and how to fill the hours, the cell displays day / month / year more 00:00:00. I want to appear only the number of hours.
Ex: 30:00

meninio · #4 02-11-2011, 06:50 AM

I found the error. The formatting that you passed is correct, it is I who was entering the values the wrong way. Instead of inserting 23:00 I was just entering the 23 would appear that counting 23:00.

Thanks for the help.

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