Benches Displays

4

Add time to displayed time

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I have a Numbers document with 1 sheet & three tables (at the moment) of sunrise & sunset times. The times are from a web-generated table based on latitude & longitude on this site.
It "insists" on using the date I created the table for all of the rows, but I can live with that since I'm not displaying the date, that's in column before. It was a bit of a "pain" to get Numbers to just display the time (24 hour clock).

What I want/need to do is add 1 hour to those times that fall in Daylight Saving/Summer Time. Since date & time is a number, how can I convert the time (all with the same date, remember) to something I can add an hour to & how much would an hour be?

4 replies

Sign in or join Beachball Help to reply.

  1. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    If a datetime is in cell B2,insert in C2 the formula :
    =B+(1/24)

    Yvan KOENIG (VALLAURIS, France) jeudi 20 mai 2010 07:04:08

  2. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I'll give it a try.

    Shouldn't that be =B2+(1/24) in C2?

    I'm going to put the original times in new columns & then hide the columns just to keep the table neat.

  3. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hello Peggy

    It seem that you missed that since the delivery of Numbers '08, I post very often formulas using what I call 'short references'

    You may perfectly use =B2+(1/24)
    but you may also use, what I do very often
    =B+(1/24)

    I like the second one because, not only it's shorter, but it give formulas which may behave correctly when we apply a sort.

    Yvan KOENIG (VALLAURIS, France) jeudi 20 mai 2010 19:52:56

  4. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thank you. This works very well.

    I just clicked in the cell to get the reference, so I didn't need to worry about adding the column reference.