Time problems?!

[Palin00]

How do I subtract two time's that are in short form(23:05) to get the difference in a integer.
Example
time1 = 15:02
time2 = 20:02

total = time2 - time1
total should be equal to 5 hrs but it doesn't work
Is there is a function for this.

[adcomp]

datediff("h",time1,time2)

[Palin00]

This is very helpful thank you, but is there a way to get the minutes in a decimal format behind the hours like 7.25 (7 hours and 25 minutes)

Thank you ahead of time

[AnneWright]

Try:

datediff("n",time1,time2)/60

Regards


Anne Wright
Wright Computing