Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

time subtraction !!

i am having 2 text boxes both are having time as the text in standard format how can i subtract both the times and get the net time for which the application was running?
0
pranay01
Asked:
pranay01
1 Solution
 
RanjiniPrabaCommented:
Hi,
you can use the Datediff() function whereby you will have to pass 3 arguments,
two of which are the dates for which you have to find the difference. the last argument is the format in which you want the difference like h for hour, s for seconds, m for months, d for days, etc. once you get the difference, you can convert it in to time again which is a simple arithmetic.
0
 
stevengannCommented:
Dim TheDate As Date   ' Declare variables.
Dim Msg
TheDate = InputBox("Enter in this format ->  " & Now)
Msg = "Hours from now: " & DateDiff("h", Now, TheDate)
MsgBox Msg
Msg = "Minutes from now: " & DateDiff("n", Now, TheDate)
MsgBox Msg
Msg = "Seconds from now: " & DateDiff("s", Now, TheDate)
MsgBox Msg
0
 
pranay01Author Commented:
thanx it worked!!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now