Hi Mike,

Not sure if you really want to use the mod function.
Check the help files for this function. It's calculating
the remainder for a division calculation: (A1+B1)/1.

Just try adding the values instead: =A1+B1

Cheers,

Mike

-----Original Message-----
I have a project that is going to be installed in
different time zones over the next few months. I have the
install dates in the local time of the install in an
Excel
spreadsheet. I'd like to calculate the time zone offsets
so I can plan times my staff has to be available for
coverage of the installations.

I've found how to add or subtract hours from a date with
the following formula...

a1 = 7/15/03 09:00 AM
b1 = 06:00
c1 = formula - =mod(a1+b1,1)
display value - 1/0/00 3:00 PM

The time difference is correct but the date doesn't
follow
through even with c1 formatted as mm/dd/yy hh:mm AM/PM

I can do this by hand but I'm going to have just under
200
sites to install.

Help!

TIA,
Mike
.