Thread: how to use if command with time in function?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Senaka Excel Senaka Excel is offline
external usenet poster
  
Posts: 1
Default how to use if command with time in function?
give example?
if in B2 cell having a time format how to identify it by using IF function?
to calculate overtime hours and minutes.
=(ifB20900,"yes","no")

Reply With QuoteReply With Quote