Thread: i want to add increments of time not time & date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default i want to add increments of time not time & date
And? Just add them, if A1 is 0 and you want to add 3 minutes and 10 seconds
use =A1+time(0,3,10) or =A1+"0:3:10"

format result as time [hh]:mm:ss

--

Regards,

Peo Sjoblom

"Bella" wrote in message
...
I am trying to add time increments of minutes and seconds. I don't care
what
time of day it is.


Reply With QuoteReply With Quote