View Single Post
 
Old 02-21-2023, 11:04 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

In case the date part is always left out, and calculated time interval will always be less then 24 hours, the formula like below will work
Code:
=(B2<A2) + B2-A2
Btw, when you enter a time value without date part, you really are entering a datetime value like 00.01.1900 19:00 (what essentially is a time value from day 31.12.1899)!
Reply With Quote