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?