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: