Grandis
OOo Advocate
Joined: 05 Mar 2007
Posts: 232
Location: Norway
|
 Posted: Thu Dec 11, 2008 2:50 pm Post subject: Add time value manualy to a cell - save time format [solved] |
 |
|
Hi.
Have a cell A1 that is formatted and contains the time 13:10:00.
Then I have A2 that I want to add 20 minutes to the time in A1 - but I don't want to us an extra cell for that.
So in A2 i wrote "=A1+00:20". All went fine, but the time in the formula in A2 is now converted to a decimal number.
I want to add a time without using a spare cell, and I want the added time format to be intact so I can read it later if I want to.
[EDIT]
Found this out:
I can use the TIMEVALUE function that returns time from a text string.
So the formula is then:
=A1+TIMEVALUE("00:20")
_________________
Windows XP sp2 |
|
