Hello,
using sheet with some informations.
There are some columns with text and one column with datetime (VBA). That column has this:
=EntryTime(A1)
=EntryTime(A2)
etc.
VBA code:
Function EntryTime(LeftCell As Range)
If LeftCell.Value <> "" Then
EntryTime = Format(Now, "dd.mm.yyyy hh:mm:ss")
Else
EntryTime = ""
End If
End Function
In desktop app it works fine. Problem is if I have this document in onedrive/sharepoint because there is word "NAME?" instead of datetime.
Desktop:
test 28.02.2024 07:31:46
Online:
test #NÁZOV?
Can anybody help me how to fix that please?
Thank you.
Bookmarks