excel - rounding down times

N

nick

I'm looking to set up a formula so that times in the
source cell are rounded down to the nearest hour.

eg
Source Cell A1 is 10:50am....the formula in cell B1 rounds
that down to 10am.
Source Cell A2 is 10:55....the formula in cell B2 rounds
that down to 10am.

The info in column B is then collated in a Pivot table
giving a per hour (10:00:00 thru 10:59:59) volume value.
In this case 2.
 
W

Wild Bill

TIME(HOUR(A1),0,0) will give you 10am in cell B1, though I can't speak
to your further operations with the pivot table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate total hours/minutes from two time cells 7
Round Down to the nearest multiple 3
Average rounded to nearest 0.50 4
Timesheet Calculation with Time Rounded 9
Rounding Time down 4
Excel Formula Bar Time Display Format 2
Rounding time UP to nearest fourth-hour 4
rounding is not consistant 3

Top