Let's say I have two date/times. The start date/time is 29th May 2020 at 20:30 and the end date/time is 30th May at 02:30. This link shows how to calculate using two cell references.
How to calculate in one cell the duration?
Something like DATEDIF but accepting the time and output of result in hours, e.g.:
=MYCLEVERDATETIMEDIFF(“29/5/20 20:30”, “30/5/20 02:30”, "H")
which results in:
Six being the elapsed time in hours between the above date/times.
What function, or combination of functions and conversions would do the trick? Note that ideally something that works as one cell function, not calculating the difference between two cell references.