| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
Threaded Mode
