My Add-In to Take time out of a Date and Time combination is not working.
Can some please help me out???
This is my function:
Function TM(D As Date)
If D = 0 Then
TM = ""
Else
TM = TimeSerial(Hour(D), Minute(), Second())
End If
End Function
I've stored this under (I use Microsoft XP):
C:\Documents and Settings\gb0384\Application Data\Microsoft\AddIns
and selected the Add-In under Tools\Add-Ins
My Excel looks like:
Cell A1 contains "9/1/2005 12:00:04 AM" and
Cell B1 contains =TM(A1)
and this gives me a "#NAME?" result
Bookmarks