View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MWH
 
Posts: n/a
Default Date Calc in hours

I'm trying to perform a date calc to produce a variance in hours
ex cell A1 3/27/2006 2100, cell B1 3/28/2006 0100, cell C1 =b1-a1, results I
would like to see is 4
This spreadsheet will be used for scheduling so both positive and negative
numbers will be used for variance numbers.


--
Mark W. Hanford