Subtotal on hour

[Guest]

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 DATA>SUBTOTALS to only look at the hour
portion of the time entry?

Thanks for your time and attention

 

[Nick Hodge]

You would be much better to summarise (group) this data in a pivot table
which can subtotal by hour

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

 

[Dave Peterson]

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.)