Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

time values

ResolvedVersion 2007

Alba has attended:
Excel Intermediate course

Time values

is possible to add time related values to excel?

Edited on Fri 9 May 2008, 23:27

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
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

Excel tip:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.