Forum Discussion
dfolk13
Nov 27, 2023Copper Contributor
Why is my If statement not working?
in my Excel i am utilizing 4 different cells to return the difference in time as an number. However I seem to be getting the wrong output and it only seems to be for a specific time (=2 hours). ...
JKPieterse
Nov 27, 2023Silver Contributor
What about this formula:
=ROUNDUP(48*C1,0.5)/2
=ROUNDUP(48*C1,0.5)/2