If I have an excel file with the dates and times how do I create a code that will sum the number between certain dates and times?
I would guess:
- read the Excel file; I usually use
openpyxlfor this, but
can read them too and there are other packages
- get the “sheet” containing the dta you want, scan the rows to get your
pairs of date/times according to your criteria
- subtract the pairs
- sum the differences?
Cameron Simpson email@example.com