Thread: Time Values and Rounding

I need a simple formula that will do the following:

1. Take the time value in A1 (say 6:30 or whatever)
2. Multiply that by 1.5 (to get time and a half) and then
3. Round the sum to the nearest 15 minutes
All cells are formatted as [h]:mm

I can do these functions separately but can't figure out how to combine them into one formula.

Thanks,
Kirk

this should work...
=VALUE(A1)*1.5
assuming there is 6:30 in cell A1 then the result in B1 is 9:45

All three formulas work great. Is there any advantage to using one over the other?

Thank you all for your help,
Kirk