This project has moved and is read-only. For the latest updates, please go here.

How to get value from cell when format is [h]:mm:ss

Mar 30 at 1:58 PM
Hiall good people,
Have question if i have column which format is:
[h]:mm:ss 
so means hours could exceed 24. For example i have two cells and that text for each:
65:34:22    (value behind is 12:22:00 AM)                        -->K2 cell
0:22:00      (value behind is  1/2/1900  5:34:22 PM)          -->K3 cell
I want to get 65:34:22 and 0:22:00


Now what i tried was:

ws.Cells("K2").Text giving me: 12
ws.Cells("K3").Text giving me: 05

then i tried before get values set format like this:
ws.Cells("K2").Style.Numberformat.Format = "h:mm:ss"
ws.Cells("K3").Style.Numberformat.Format = "h:mm:ss"
ws.Cells("K2").Text giving me: 0:22:00 --> GOOD !
ws.Cells("K3").Text giving me: 17:34:22 --> WRONG

i also tried with this formatting:
ws.Cells("K2").Style.Numberformat.Format = "[h]:mm:ss"
ws.Cells("K3").Style.Numberformat.Format = "[h]:mm:ss"
ws.Cells("K2").Text giving me: 12 --> WRONG
ws.Cells("K3").Text giving me: 05 --> WRONG
Apr 1 at 2:03 PM
is this not available in Epplus or anyone any feedback?