Time format gives incorrect values

[mahmed1]

Hi All

I have some time that i extract that is shown in milliseconds...

A2 - 5615835897
A3 - 9775864764
A4 - 10008363930

To convert this in to a time format
I do A2/1000/86400 formatted as hh:mm:ss
If i format as [hh]:mm:ss i get incorrect time

Now when i add A2:A4 and divide by 1000/86400 or even at the formatted time

I get completely incorrect summed value something like 239:48:56 etc...

What am i doing wrong?

I just want to convert to time and add them
Up

 

[6StringJazzer]

When I do your calculation and format the result as [hh]:mm:ss I get correct answers. Why do you think these are incorrect?

$scratch.xlsm
	A	B	C
1	Time in milliseconds	Time in hh:mm:ss	Time in Days
2	5615835897	1559:57:16	64.99810066
3	9775864764	2715:31:05	113.1465829
4	10008363930	2780:06:04	115.8375455
ms

Cell Formulas
Range	Formula
B2:B4	B2	=C2
C2:C4	C2	=A2/1000/86400