Thread: How to assign unit for TimeValue?
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Modeste[_2_] Modeste[_2_] is offline
external usenet poster
  
Posts: 6
Default How to assign unit for TimeValue?
Bonsour® "Eric" a écrit

A1 = 30
A2 = A1*"0:1", which show 00:30:00 in hh:mm:ss format

dTime = Now + TimeValue(Sheets("Date").Range("A2").Value)

dTime = Now + Sheets("Date").Range("A2").Value
or
dTime = Now + TimeValue(Sheets("Date").Range("A2").Text)

;o)))


Reply With QuoteReply With Quote