Return the time elapsed between 2 times


 AB
1=NOW() = 6:02:29 AM 
2=NOW()+0.5 = 6:02:29 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 

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