Thread: help with time formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cjbarron5 cjbarron5 is offline
external usenet poster
  
Posts: 33
Default help with time formula
I have this formula =TEXT(D2-C2,"h:mm") but when d2 and c2 are empty it
displays 0:00 I think I can use =if(isna.........but I cant get the format
right
any ideas?
thanks
Reply With QuoteReply With Quote