Hi,
I'm using a spreadsheet to keep track of my driving times, to make
sure I get all the hours needed to get my license. All I have now is
a column for START TIME, END TIME, NOTES, MINUTES, and TOTAL. I'm
currently using the NOTES column to state whether or not the time is
at night. The problem with that is I am not good at doing math with
time, so I can't tell how many minutes of driving I have done at
night.
I'm simply wondering if there is a way to only add the times from the
minutes column if either a) the NOTES column states that it was at
night, or b) if the times are later than a specified time.
Have a look at the SUMIF() function...
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus