Negative time delta values should format correctly #2587

New Issue

2020-10-01T19:04:27Z

snoopyjc commented

2020-10-01 19:04:27 +00:00

(Migrated from github.com)

In Excel, a negative time difference formats with a negative sign. SSF returns a blank result:

console.log('"' + SSF.format('[HH]', -12) + '"')
""

In Excel, a negative time difference formats with a negative sign. SSF returns a blank result: console.log('"' + SSF.format('[HH]', -12) + '"') ""

SheetJSDev commented

2022-07-07 05:34:32 +00:00

(Migrated from github.com)

Interesting -- the absolute time tokens will be displayed as negative numbers while the normal datetime tokens elicit a #VALUE! error:

Interesting -- the absolute time tokens will be displayed as negative numbers while the normal datetime tokens elicit a `#VALUE!` error: <img width="183" alt="issue2587" src="https://user-images.githubusercontent.com/6070939/177699036-9c727c50-cfe4-4e7c-9d4d-cdfb4d78fcb5.png">

Sign in to join this conversation.