Round Time to 30 minutes
 

Hello All,

I want to write a function that will round my stat time and end time fields
to 30 minutes.

i.e. if start time is 10:20 it should be converted to 10:30 and if it is
10:40, it should be converted to 11:00 so on and so forth.

Your help on this will be much appreciated

Round Time to 30 minutes
 

One way:

=ROUNDUP(A1*48,0)/48

--
Kind regards,

Niek Otten


"Shiv" wrote in message ...
Hello All,

I want to write a function that will round my stat time and end time fields
to 30 minutes.

i.e. if start time is 10:20 it should be converted to 10:30 and if it is
10:40, it should be converted to 11:00 so on and so forth.

Your help on this will be much appreciated