esfalsa / srsglass

A command-line utility for generating NationStates region update timesheets
GNU Affero General Public License v3.0
1 stars 2 forks source link

Datetime format incompatible with Spyglass #1

Open esfalsa opened 9 months ago

esfalsa commented 9 months ago

cc: @rootabeta

srsglass saves estimated update times as an actual Excel datetime (which have an underlying data type of a 64-bit floating-point integer^1). Spyglass just concatenates the number of hours, minutes, and seconds with colons in between, without adding leading zeroes as appropriate. I find the Excel datetimes to be a more sensible default for srsglass, but a compatibility mode that just concatenates some numbers and colons together could be useful for any third-party tooling that is still expecting string data.