"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
|