Hi, I can barely do formulas in excel and have managed to stump myself
(not hard though). I wanted to make a time schedule chart (for a
radio show) where one column was the time the show started (using 24
instead of 12 hour clock) and the other column was the time the show
stopped, and then have a box where I could put _-/+ how many hours
difference there was between where I am (time zone) and where the show
is being broadcast. Eg. I am in Italy (6 hours diff form EST) and the
show starts at 13:00 in the US so I want to be able to put +6 in a box
and have the time (in all the boxes) show 13:00+6. The main problem I
am having is once I get to something like 19:00 if I add 6 it goes to
25 and beyond instead of 01:00. If anyone out there has any ideas on
how to resolve this I would *really* appreciate the help!

Cheers

-Gaiko