Hi - Dave here.
Last week, we looked at a
simple way to strip times from dates, without affecting the dates. This week I have an example that shows how to sum time in Excel.
Dates and times are just numbers in Excel, so you can use them in any normal math operation. However, by default, Excel will only display hours and minutes up to 24 hours. This means you might seem to "lose time" if you are adding up time that is more than 1 day.
The solution is to use a custom number format that will display elapsed time instead of time of day. The worksheet below shows what this looks like in action:
[
download the workbook and read the full explanation]
This is also a good example of how Excel Tables can make formulas easier to read, write, and maintain. Download the workbook and have a look. If you add new entries to the table, the time will automatically appear in the results.
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a fun and safe weekend!
Dave
