Cell with hours

		Microsoft Office Forums > Microsoft Excel > Excel
Cell with hours

02-11-2011, 06:19 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Cell with hours

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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?

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:38 PM.