Note that appscript uses current date if only time is given

Excel to Python returns a float in any case, not a datetime object.

I'm looking to return datetime.time objects from Python to VBA. I just want to check, is this the right issue to address that?

@xw.func
def test_time():
    return datetime.time(1, 2, 3)

@xw.func
def test_date():
    return datetime.date(2001, 2, 3)

@xw.func
def test_datetime():
    return datetime.datetime(2001, 2, 3, 4, 5, 6)

Basically, the issue is that Excel doesn't have a time-only type. A time-only cell has the date 1/1/1900, so you should be able to send over a datetime object with 1/1/1900 as the date and then assign the right number_format to format it as time-only.

Thanks for the workaround! Any chance of getting that into _datetime_to_com_time as default behaviour? I agree it's weird, but if that's the only way Excel can represent time-only things, then that's probably what we should use.

I'm trying to make a PR but failing miserably so far. I can't figure out where the error originates.

I added this to _datetime_to_com_time:

    if type(dt_time) is dt.time:
        # Excel does not have a time-only data type. It stores times with date `1900/01/01`.
        dt_time = dt.datetime(1900, 1, 1, dt_time.hour, dt_time.minute, dt_time.second,
                              tzinfo=win32timezone.TimeZoneInfo.utc())

but it looks like the error is thrown before _datetime_to_com_time is reached.

you'll also need to add dt.time to
https://github.com/xlwings/xlwings/blob/main/xlwings/_xlwindows.py#L91

or it's not triggering that conversion in:
https://github.com/xlwings/xlwings/blob/main/xlwings/_xlwindows.py#L459

This feature will be really helpful, thanks