Return the time elapsed between 2 times


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

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