How to convert Time format from from 0.583333333333333 to 24 hr

Help Activities
, , ,
1

Hi All,

I have excel sheet in that Time is mentioned like this in column :

Time
7:31 PM
07:32 PM
07:33 PM
07:34 PM
10:00 AM

But i get display result as this :

image
image1863×279 15 KB

Can anybody help me out with this to convert Time format from 0.583333333333333 to 24 hr (18:50 PM)

Thanks,
Muralikrishna

4

can you check if the double should really result to 18:50?
Also have a look here:
grafik

1 Like
5

Use DateTime.FromOADate method for that conversion, see this documentation

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.