Return the time elapsed between 2 times


 AB
1=NOW() = 7:03:31 AM 
2=NOW()+0.5 = 7:03:31 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 

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