On 6 May 2010 09:41, Richard Travers <[email protected]> wrote: > In article <[email protected] > >, > Harold Fuchs <[email protected]> wrote: > > > In Calc I have a column of date/time values formatted as hh:mm:ss (all > > the dates are the same and are irrelevant). How do I add one hour to each > > value? > > > OOo 3.1, Win XP Pro. > > Assuming dates/times in column C, starting at C4, and you want the amended > dates/times in a different column (say, D), then in D4 put the formula > =C4+1/24. Then Fill down. Adding 1 appears to add a day, so 1/24 adds an > hour, 1/1440 adds a minute and so on. > > R. > > > Thank you.
-- Harold Fuchs London, England Please reply *only* to [email protected]
