Converting Generic value to DateTime format

Help
1

Hi,
Am trying to automate production report email process.
In this process, I have to read total production of each member and need to highlight which are lagging behind standard time.
I am able to read “10:30:39” from excel using generic value but not able to convert back to time to do computation.
Sample:
Excel value:
10:30:45
09:30:45
10:20:05
10:40:45
10:30:45
Now i need to highlight values which are below “10:30:00”. Because of reading it as generic it shows some thing like 0.53453455.

Any Idea ?

2

Hello there,
Assign dateVar=DateTime.FromOADate(timeValue)
datevar.ToString(“HH:mm:ss”)

Here we go.
generictoDate.xaml (10.3 KB)

2 Likes
4

Thanks Bro, It works.

1 Like
5

how to change the excel format generic to custom