View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jafferi[_2_] Jafferi[_2_] is offline
external usenet poster
 
Posts: 22
Default Calculating a date


Cell A1 ~ Jan 1, 2009
Cell B1 ~ [if Cell A is a date, multiple by 8]

Basically, I want the cell to acknowledged that a day is equal to 8 hours.
Can you help to figure out how can I do this?

Thank you in advance.