View Single Post
  #5   Report Post  
Rob van Gelder
 
Posts: n/a
Default

Of course!
I like it.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Harlan Grove" wrote in message
...
"Rob van Gelder" wrote...
Assuming one of your times is in A1

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

...

2 function calls for each time value. Can reduce this to 1. Given two
times
as integers in A1 and A2, with A1 < A2, the minutes between them could be
calculated as

=(TEXT(A2,"00\:00")-TEXT(A1,"00\:00"))*1440