Text + SUM of cells decimals error

[Olisthoughts]

I'm working on a break list for my team at work.

I want a very simple calculation to count the values in cells and return their number, with the text "currently on break: " in front of it.

If I just use =SUM(C4:C16) it works perfect and returns me the number, but using ="Currently on Break: "&SUM(C4:C16) is returning a result with decimals. and sometimes wrong overall.

I've tried formatting the cell in different ways to remove the decimals, it did not work.

Please show me what I'm doing wrong, screenshots attached.

Thank you.

 

[Fluff]

You need to use count instead of sum.

 

[Olisthoughts]

Thanks a lot!

 

[Toadstool]

Hi Olisthoughts,

You can use the TEXT function to format as you want:

Book1
	C	D	E
4	1:23		Currently on break: 15:41
5
6	2:12
7
8
9
10	4:33
11
12
13
14
15
16	7:33
Sheet1

Cell Formulas
Range	Formula
E4	E4	="Currently on break: "&TEXT(SUM(C4:C16),"hh:mm")

 

[Fluff]

Thanks a lot!

You're welcome & thanks for the feedback.