Subtotal on hour
 

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

Subtotal on hour
 

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
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"JR Hester" wrote in message
...
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

Subtotal on hour
 

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