Formula to Auto popluate Hours

[Parth007]

Hi Members,

Need to auto populate Hours on the basis of Data in Column H,

Example..

If column H have value as 15:29:00
then Column F should get value the next hour break in it..
Column F = 15:30:00

IF column H = 16:42:00
Then Column F should be = 17:00:00

Attached sample have sample data in it..

Please suggest

[Bernie Deitrick]

If you want the next half-hour time, use this formula, formatted as time, for a time entry in H2

=ROUNDUP(H2*48,0)/48

For the next 15 minute interval insted of half-hour, use

=ROUNDUP(H2*96,0)/96

[Parth007]

Thanks Bernie.. Got a way through ....