Thread: Adding Time Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Adding Time Function
Hi Joe,

If cell B2 has a duration of 21 seconds,
use time function, in B3 : =time(0,0,B2)
and then just add, in B4 : =A2+B3

HTH
Cheers
Carim

Reply With QuoteReply With Quote