Often when you import data into Excel the dates may include a time. This can make summarising the data more difficult as time is included as a fraction of a date. You can use an old function to fix the problem. This solution requires the subscription version of Excel.
Tag Archives: Time
Extracting Time from Date and Time in Excel
Another MOD function solution
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.
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.