Calculating time difference

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

I have two fields with Time From and Time To. I would
like to calculate difference between these 2 time values.
Can anyone suggest an expression for this? Thanks.
 
The DateDiff function will give you the time difference in whatever unit you
want. For example, DateDiff("s", [Time From], [Time To]) will give you the
difference in seconds.
 
DAMN IT!!!
I am a day too late.

I needed this function so I created this exact same thing.
It took me a few hours, but it does that same thing. Only
I didn't go down to the seconds, I rounded the seconds to
the min and went from there.

Oh well, it was fun though.


-----Original Message-----
The DateDiff function will give you the time difference in whatever unit you
want. For example, DateDiff("s", [Time From], [Time To]) will give you the
difference in seconds.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



I have two fields with Time From and Time To. I would
like to calculate difference between these 2 time values.
Can anyone suggest an expression for this? Thanks.
Click to expand...


.
Click to expand...
 
Back
Top