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.
Printable View
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.
datediff("h",time1,time2)
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
Try:
datediff("n",time1,time2)/60
Regards
Anne Wright
Wright Computing