Rounding up to 15mins

[Squidge]

Hi Guys

I am trying to round up peoples additional travel time, but I have already used 1 formula to convert decimals into time format.

I need to now round up this converted time to 15mins of an hour (not the nearest 15)

If a formula can be made so only 1 is needed then even better (combining the conversion of decimals into hours and rounding up to 15mins)

I have attached a part of the spreadsheet

Hope you can help

Thanks in anticipation

Squidge

[zbor]

Try =MROUND(N2, "00:15") and format as time

[DonkeyOte]

Use either:

=CEILING(K2/24,"00:15")
format as hh:mm

or:

=CEILING(K2,0.25)/24
format as hh:mm


@zbor - MROUND is ATP dependent pre XL2007 - it will also round to nearest rather than round up as requested.

[zbor]

correct...

[Squidge]

Thanks Donkey Ote

This has resolved my issues

Thanks Zbor too

Squidge