hi all and thanks for any help.

doing somethign a bit crazy here. writting a macro that takes a time, converts it from it's local time to my time, then adds a number of hours to it.

i get a report that has any number of rows of data and each one has a time stamp from it's own local time. i need to covert that to MY time zone (done) and then add on number figure (currently int value rounded to no decimal places). this is where i am getting into trouble.

i have been trying to use TimeValue("xx:xx") but dosen't seem to work my time value is always changing. any suggestions?

eg

1) current time is 18:05 PST
2) my time is 16:05 CST
3) i want to add say between 0-24 hrs to this time to come up with new time...any ideas?