Excel stores dates and times in days. As 168 hours is 7 days, adding 168
hours is as simple as:
=a1+7

Regards,
Fred

"losing it" <losing wrote in message
...
As a relative newbie to excel formulas I'm having great difficulty
creating a
formula where I need to add 168 hours to a date/time. After two days of
trying I'm losing my mind :-(

Column A contains the Date/Time (I've tried many formats to no avail) and
I
need column B to show the result of adding 168 hours to A1. Any help might
keep from the asylum.

I've have read and re-read Chip Pearson's great work and still can't
figure
this out!