Hi all,
When exporting an x-y chart, the time value is some large number. How do I convert this to the actual time of day?
Thanks,
Art
Hi Art,
I have attached an excel spreadsheet that has a formula cell the calculates these values for you.
The formula is: (D1 is the cell that is being converted)
=TIME(MOD(D1/'Conversion Factors'!$C$2,24)+'Conversion Factors'!$A$2,MOD(D1/'Conversion Factors'!$D$2,60),MOD(D1/'Conversion Factors'!$E$2,60))
If you add the "Conversion Factors page to your excel spreadsheet and copy the converted forumula in B16, you should be good to go.
Let me know whether you have any problems with it.
-Adam
I have multiple graphs and am comparing the data using a time hack. It would be nice to have a time-of-day mark like what is seen in the iTest charts.
Are you using this inside or outside of iTest? If you are putting it into excel I could create an excel example that might help. If it is inside iTest, I could help create a Test Case that performs these computations.
Do you want the format to be HH:MM:SS.sss or just HH:MM:SS?
Or would you be happy with a decimal hour equivalent? i.e. 13.5 hours for 13:30:00.
-Adam
Hi Art,
The time values are milliseconds from 1970 GMT.
How are you trying to use it? I might be able to help figure out what calculations you need to perform.
-Adam
