When exporting an x-y chart, the time value is some large number. How do I convert this to the actual time of day?
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.
No one has followed this question yet.