Columns doesnt count right


So I got this example:


The green value should show 01:00:00 but it doesnt. I think the formula I got "ROUND" it somehow (I got the code online). And I need this code so the value can exceed 24 hours. I've tried to remova "ROUND" in the code but only getting syntax errors.


IF(INT(Minuter/60)<10;"0"&INT(Minuter/60);INT(Minuter/60))&":"&IF(ROUND((((Minuter/60)-INT(Minuter/60))*60);0)<10;"0"&ROUND((((Minuter/60)-INT(Minuter/60))*60);0);ROUND((((Minuter/60)-INT(Minuter/60))*60);0))&":"&TEXT([Ärende påbörjat]-[Ärende inkommet];"ss"))


Can someone help me?

1 Reply



Try the below syntax:


=DATEDIF([Eff Dt],[Exp Dt]-(MOD([Eff Dt],1)>MOD([Exp Dt],1)),"d")&" days, "&TEXT(MOD([Exp Dt]-[Eff Dt],1),"hh "" hrs, "" mm "" mins""")


,where Eff Dt and Exp Dt are field names. Results are shown below (Diff field - calculated column) as an example.




Hope this helps!

Related Conversations
Counting Days
Tim Hunter in SQL Server on
2 Replies
How to count multiple values in a cell
Ugarte335 in Excel on
7 Replies
Count until
MBelshaw in Excel on
1 Replies
Pivot table
gabriellerocha in Excel on
5 Replies
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies