Return the time elapsed between 2 times


 AB
1=NOW() = 12:28:52 PM 
2=NOW()+0.5 = 12:28:52 AM 
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