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