Hi,
I'm trying to calculate the number of seconds between two variables with dates in them in dd/mm/yy hh:mm:ss format. The variables are dimmed as date. I literally just want a long results giving something like: 338981 seconds.
I'm missing something obvious...thanks for any help!
Also, just out of interest, does anyone know why the following doesn't give a whole number?:
MsgBox Now / 1.15740695036948E-05
The reason I ask is, I thought I could just divide both dates by the number of seconds (1.15740695036948E-05) since date=0 and compare them like that...but I'm getting decimals...?!
I'm trying to calculate the number of seconds between two variables with dates in them in dd/mm/yy hh:mm:ss format. The variables are dimmed as date. I literally just want a long results giving something like: 338981 seconds.
I'm missing something obvious...thanks for any help!
Also, just out of interest, does anyone know why the following doesn't give a whole number?:
MsgBox Now / 1.15740695036948E-05
The reason I ask is, I thought I could just divide both dates by the number of seconds (1.15740695036948E-05) since date=0 and compare them like that...but I'm getting decimals...?!
Last edited: