rounding hours and minutes to the nearest hour

[rochandac]

I need to convert hours and minutes to the nearest hour. For example 3:22 would become 3 hours. Is there a way to do this in excel?

Is it possible for me to convert hours and minutes to the nearest decimal? For example 3:22 would become 3.67.

 

[barry houdini]

I'm not sure how 3:22 would become 3.67

If you want to show a time in decimal and round to the nearest hour then you could use this formula

=round(A1*24,0)

format as general

where your time is in A1

 

[rochandac]

Rounding hours

Thanks.

How do I round to the nearest hour?

 

[Scott Huish]

If you want to show it as time:

=ROUND(A1*24,0)/24

 

[barry houdini]

That does round to the nearest hour in that if A1 contains 3:22 it will return 3, if you just want to return the hours in time format 3:00 then you can use

=ROUND(A1*24,0)/24

or using MROUND function from Analysis ToolPak

=MROUND(A1,"01:00")

in both cases format as time