View Single Post
  #5   Report Post  
Max
 
Posts: n/a
Default

Works great, Peo !
Thanks ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Peo Sjoblom" wrote in message
...
Another way


=(MOD((INT(LEFT(B2,4)/100)+MOD(LEFT(B2,4),100)/60)/24-(INT(LEFT(A2,4)/100)+M
OD(LEFT(A2,4),100)/60)/24,1)*1440)

Regards,

Peo Sjoblom