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. -- Richard Travers [email protected] Truro, Cornwall --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
