I had a recent query regarding checking time in a column that had both date and time. There is an easy way to extract time from a date-time combination.
Tag Archives: Time
Time differences in Excel
ABS to the rescue again
Here’s a technique to calculate the time differences when you aren’t sure which time is first or last. Note with standard Excel settings you cannot report negative time.
Negative Time in Excel
Party like its 1904
It is possible, but it involves a setting change that comes with a warning.
Another date solution
Formula to the rescue
Getting dates into order is usually a job for Power Query, but not everyone has it or uses it so I still get requests for formulas to fix text dates.