79560103

Date: 2025-04-07 14:13:47
Score: 1
Natty:
Report link

Here's a way to do it in one formula from full hex strings (e.g. 677406d7a099d0ce7fc5ae60)

=TO_DATE(hex2dec(left(A2,8))/86400+DATE(1970,1,1))
Reasons:
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Ernest