Open AmandaAmAlBa opened 2 years ago
Assuming you have the timestamp value in cell A1, the excel formula is the following: =(((A1/60)/60)/24)+DATE(1970,1,1)
I am a bit reticent in adding redundant data to the CSV file... or at least not having the option of having a memory efficient csv summary of the annotations. Maybe I'll add a new menu option with extra redundant data like date and time format of start and end timestamps, duration etc.
It would be very useful to have the date and time of day of each annotation when exporting the csv file. In the meantime, could you share the formula that allows to onvert the current time stamp into date and time please?