Home

Columns doesnt count right

Highlighted
288088
Contributor

So I got this example:

missingonemin.PNG

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

@288088 

 

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.

 

clipboard_image_0.png

 

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