# Sum formula only using whole numbers

Hi

This is my board i’m working on

1. I have a formula column called (Jordan approx shift length) It’s set up to find the difference within hours.

2. I have another formula column set up (Jordan total hours) set up to Sum that column

Heres the problem = 2. (jordans total hours) only sums whole numbers. You can see the example in the Friday row of the board. How do I get it to sum the half an a hour as well?

@J.Low

The problem is not with SUM() but with how the HOURS_DIFF() result is interpreted numerically.

Try changing your “Jordan total hours” formula to:

`(TIMEVALUE("1/1/1 " & {Jordan out}) - TIMEVALUE("1/1/1 " & {Jordan in})*24`

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Is the System Down or is it just me?
Contact me directly here: Contact – The Monday Man

@JCorrell

Thank you for your help. It’s much further than any of my knowledge.
I tried that formula and this is the result;

It’s not quite right… any ideas from here. Thank you

@J.Low

Sorry about that. I tested it before I pasted the formula… but for some reason there is a “)” missing. Try this one:

`(TIMEVALUE("1/1/1 " & {Jordan out}) - TIMEVALUE("1/1/1 " & {Jordan in})) * 24`

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Is the System Down or is it just me?
Contact me directly here: Contact – The Monday Man