| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rounding time to nearest Hour
In Excel, is there a way to round off time to the nearest hour. 6:10 would
become 6:00; 6:30 would be 7:00. |
|
#2
|
|||
|
|||
|
One way
=ROUND(A1/(1/24),0)*(1/24) where A1 holds your time, format as time or you'll probably get a decimal number -- Regards, Peo Sjoblom (No private emails please) "SierraRose" wrote in message ... In Excel, is there a way to round off time to the nearest hour. 6:10 would become 6:00; 6:30 would be 7:00. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate time difference to the half hour | Excel Worksheet Functions | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
| rounding time question | Excel Worksheet Functions | |||
| Round Time with Conditions | Charts and Charting in Excel | |||
| How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
Linear Mode
