time values
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
Customer: Sign in
Delegate: Sign in
Trainer: Log in
Home Course details Training formats Pricing FAQ Clients Book online Online schedule (live) Forum Contact us

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Time values

Time values

The UK's most regular instructor-led training courses.
Training information: excel one day course london · Excel course london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

resolvedResolved · Low Priority · Version 2007

Time values

Alba has attended:
Excel Intermediate course

by - delegate Alba [1 post] (2008 May 9 Fri, 17:11) replyReply

is possible to add time related values to excel?

Excel Intermediate 1 day course List price £225
Version Date Location Places
available
Book Next place rate:
Card Invoice
2007 2008 May 19 Mon Bloomsbury 0 FULL    
2003/XP 2008 May 20 Tue Tooting 0 FULL    
2003/XP 2008 May 20 Tue Bayswater 1 book now £195 £205
2003/XP 2008 May 22 Thu Bloomsbury 7 book now £188 £215
2003/XP 2008 May 29 Thu Southwark 4 book now £207 £215
2003/XP 2008 Jun 3 Tue Bayswater 5 book now £198 £215
Full Schedule: See all 169 Excel Intermediate course dates.
Bookings currently available until 25th November 2009.

RE: Time values

by - trainer Pete platinum contributer[571 posts] (2008 May 9 Fri, 23:27) Edited on 2008 May 9 Fri, 23:27 replyReply

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
Once you have entered this value as a time, you can calculate the total, between 2 or more cells, you can find the difference, add minutes and even seconds to the values, if your sum is greater than one day you will be given the value for the time in the following day, it will run sequentially, eg 12:00 + 12:15 will give the answer 0:15. I hope that has answered your question, best regards Pete


Related articles

· Advanced Excel Training - takes you to the next level
· Identifying Suitable Candidates For VBA For Excel Training
· Microsoft Office and the Small Business: Part 1 Excel
· How to check for and reduce errors in Microsoft Excel
· Microsoft Excel Training: Essential for Today's Employees

Please browse our web site to find out more about
excel one day course london and other Microsoft training courses.

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider Institute of IT Training - Accredited Training Provider Prodigy Platinum Learning Partner Microsoft Office Specialist Authorised Testing Centre

Microsoft Registered Partner
microsoft office
ms office project server

Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
microsoft+access+training · access courses in london

Training Information