View Single Post
  #1  
Old March 13th, 2010, 02:32 AM posted to microsoft.public.excel.misc
losing it
external usenet poster
 
Posts: 1
Default Formulas using time and dates

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!