How to round time to the next hour

[Bugas]

I'm trying to identify the time that employees stoped the work, rounding up the time. Without using VBA is there any formula in excel to this?

In this example I show in Column C the final result. If they stop at 05:00, the result should be 05:00. If they stop at 09:01, the result is 10:00. I want to round up time.

Thanks

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Employee name[/TD]
[TD="align: center"]End time working[/TD]
[TD="align: center"]Round up Time[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Alan[/TD]
[TD="align: center"]05:00[/TD]
[TD="align: center"]05:00[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Bruce[/TD]
[TD="align: center"]09:01[/TD]
[TD="align: center"]10:00[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]Charlie[/TD]
[TD="align: center"]06:30[/TD]
[TD="align: center"]07:00[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]Danny[/TD]
[TD="align: center"]07:45[/TD]
[TD="align: center"]08:00[/TD]
[/TR]
</tbody>[/TABLE]

 

[My Aswer Is This]

Try this:

[/SIZE][SIZE=6][SIZE=1]=ROUNDUP( B2*24, 0) / 24[/SIZE]
[/SIZE][SIZE=1]

 

[mikerickson]

Or
=CEILING(B2, 1/24)

 

[Bugas]

Try this:

[SIZE=6][SIZE=1]=ROUNDUP( B2*24, 0) / 24[/SIZE]
[/SIZE]

Thanks! It works

 

[shg]

Or

=CEILING(B2, "1:00")