View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Derek
 
Posts: n/a
Default perform calculations using time arguments

How to perform calculations using time as arguments?

E.g. "F1-F2" works fine where both cells contain values with (h:mm) format,
but "F1-8:00" returns an error. Also, when using =IF(), when [value_if_true]
is "f1-8:00" I get a formula error.

what up?