I need help with a formula, I want to put a start time and finish time into two cells and the answer needs to be to the nearest 15 minutes. ie 08.05 would be 0800, 07.25 would be 07.30 etc..
I have managed to find this that does the basic bit but not the rounding out.

=IF(C1<B1,((C1-B1)*24)+24,(C1-B1)*24)

but I find to put time in I need to put colons in and I would prefer to just type 0730 and not 07:30,I thought the time format would allow that but all I get is strange numbers coming up.

any help greatly appreciated

Bill Reed