I don't think so.

But if you already have your data sorted and don't care about seeing the real
time, you could format that column to just show the hours:

HH
or
HH AM/PM

And do your data|subtotal against that.

(I'd do what you're doing.)

JR Hester wrote:

A colleague has a spreadsheet that we need to subtotal at each change in
hour. Time is stored in a column in time format, hh:mm:ss. We have created
another column using formula =hour(time) then fill this throughout the
appropriate range. This process is repeated every day as new data is acquired.

? IS there any way to direct the DATASUBTOTALS to only look at the hour
portion of the time entry?

Thanks for your time and attention

--

Dave Peterson