Return the time elapsed between 2 times


 AB
1=NOW() = 8:58:47 AM 
2=NOW()+0.5 = 8:58:47 PM 
3=MOD(A2-A1,1) = 12:05:00 AM 
4=MOD(TIME(21,36,0)-TIME(3,0,0),1) = 6:36:00 PM 

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top