I figured out how to put the blank instead of a 0 (through Tools/Options/View
- Zere Values).
I did notice that when there is a different hour, that the formula will just
look at the minute section. For instance:
12:08:00 PM
12:12:00 PM
12:12:00 PM
12:15:00 PM
5:19:00 PM
5:19:00 PM
5:25:00 PM
Between 12:15 and 5:19, I get 4 minutes. How do I get it to tell me 5 hours
4 minutes or 304 minutes?

"Natalie" wrote:

Thanks, Dan! That does work out well. One quick addition: How do I get it to
leave a blank instead of putting a 0 when the time has not changed?

"dan dungan" wrote:

if your list of times is in column A,
put this formula in column B:

=IF(ISERROR(MINUTE(A9-A8)),"",MINUTE(A9-A8))

then select column b, Choose "Conditional Formatting", from the Format
menu, and enter the criteria and formatting you desire.