Date Time Question

[srroduin]

I'm writing code that will subtract one hour from the time that the person
types in. If the person types only a date and not a time Excel defaults to
00:00 for the time portion. That's the answer I want for that case only.

How would I word an if statement to say if SASStartHE is typed as date 00:00
then SASStartHE = SASStart else SASStart = Dateadd("h", -1, SASStartHE).


Any ideas are greatly appreciated.

 

[Bob Phillips]

=IF(SASStartHE=0,0,SASStartHE-TIME(1,0,0))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Tom Ogilvy]

if Int(SASStartHE) = SASStartHE then
' do nothing
else
SASStart = Dateadd("h", -1, SASStartHE)
end if

 

[srroduin]

It worked great! Thanks so much.

if Int(SASStartHE) = SASStartHE then
' do nothing
else
SASStart = Dateadd("h", -1, SASStartHE)
end if