Thread: How can I calculate the difference between times without using th.
View Single Post
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default
Neat Rob

I just gotta learn to never say never.

Gord

On Sun, 23 Jan 2005 10:05:49 +1300, "Rob van Gelder"
wrote:

Assuming one of your times is in A1

=INT(A1 / 100) * 60 + MOD(A1, 100)

Reply With QuoteReply With Quote