ASP Math: Get amount of time between two values (such as 10/23/2008 2:30:00 and 10/23/2008 4:30:00)?
Posted on 2008-10-23
Using Classic ASP, I need to get the amount of time (in hours) between two values:
- 10/23/2008 2:00:00 to 10/23/2008 2:20:00 = 0.33
- 10/23/2008 7:45:00 to 10/23/2008 11:30:00 = 3.75
I've researched 'datediff' and 'dateadd' with no luck. I cannot seem to find any examples of 'datediff' using the time, only the date, but apparently you get get number of seconds/minutes/hours.
Thanks in advance,