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

	A	B	C
1	Employee name	End time working	Round up Time
2	Alan	05:00	05:00
3	Bruce	09:01	10:00
4	Charlie	06:30	07:00
5	Danny	07:45	08:00

<tbody>
</tbody>

 

[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")