![]() |
|
![]() |
![]() | Customer: Sign in Delegate: Sign in Trainer: Log in |
|
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Time values Time valuesThe UK's most regular instructor-led training courses.
Time values
Alba has attended:
is possible to add time related values to excel?
RE: Time values
Hi Alba, Thank you for your post, welcome to the forum, in response to your question, I am not 100% sure what you mean, you can use time in Excel because time is expressed as a value, if you wish to have the time displayed in a cell you should enter hours:minutes:seconds separated by the full colon (:) example 12:15:30 Excel will recognise that this is to be a time value, and will enter it in the cell accordingly, if you change the value to a number (General) Excel will display it as a decimal part of a full day (1) so therefore noon will be 0.50
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Mini sitemap. These are the main areas of our web site. Full sitemap. |
© 2008 Software Training London. All
Rights Reserved. A Microsoft software training company.
info (at) microsofttraining (dot) net
All prices offered for business users and exclude VAT. E&OE