Learn how to deal with dates in Excel. You'll learn how to calculate the days, months, or years between any two dates. You'll also learn two different ways to extract the day, month, or year out of a date.
Paul: Is there a way to do time? ie 10: 05 on one date and minus it from 11: 05 the next day to come up with 25 hours? I use this to track my electric meter readings. I enter the date in column A, reading in column B, and time in column C. I then subtract those entries from the previous days to find out how much kWh I used for the day plus how many kWh I averaged using per hour. Hopefully, this makes sense. Date: 2022-04-12
