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

Assuming one of your times is in A1

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

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


"KELSEY1022" wrote in message
...
I would like to use Excel to calculate total minutes between two times,
without using the colon sign (it would be so much faster). 1315 to 1525
would be 130" not 210.