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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanx it worked!!
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.