in excel
column A - date as one long number year then month then day eg 19401231
column B - time in 24 hour clock but without leading zeros eg 1500 for 3pm 7 for 7 minutes past midnight
column C - log entry
new row for each log entry
then save as .csv
I think this is what I do, but my excel is on a different laptop.
if this doesn't help, I'll have a closer look for you on my other machine
|