Sum formula only using whole numbers

[J.Low (Jordan)]

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?

Please and thank you

[JCorrell (Jim - The Monday Man)]

@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

[J.Low (Jordan)]

@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

[JCorrell (Jim - The Monday Man)]

@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