Link to home
Start Free TrialLog in
Avatar of pranay01
pranay01

asked on

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?
Avatar of RanjiniPraba
RanjiniPraba

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.
ASKER CERTIFIED SOLUTION
Avatar of stevengann
stevengann

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pranay01

ASKER

thanx it worked!!