On Oct 11, 10:01*am, Bernd P wrote:
Hello Debbie,

B47:K47 are 10 cells, not 5. Which cells are containing your data and
how are they formatted (integer numbers, date / time format, ...)?

Can you show some sample data?

Regards,
Bernd

I have a formula in cell B47, then the B48 is blank and so on.

This is the formula in the 5 cells.

=IF(H46="s","2:00",IF(H46="CLOSED","0:00",IF(H46=" A","2:00",TEXT(I46-
H46,"h:mm"))))