How to convert a datetime.time type to float in python?

Question

I am performing a data analysis with python. I need to convert a data type from datatime.time to float, something like what makes Excel when we change the cell format from "time" to "number".

I could load the data on excel, change the columns format, export them again to CSV and finally load again into a dataframe, but I don't want to perform all that process again.

Thanks for your help!

How do you want to convert it to float? Do you want the representation of time as seconds from the epoch? As the fraction of the day that has passed? Or what? — Bakuriu
– Bakuriu, Commented Sep 16, 2016 at 16:17
@Bakuriu it seems clear from the question that they want the same decimal number that Excel displays, however it calculates it. — Mark Ransom
– Mark Ransom, Commented Sep 16, 2016 at 16:27

Mark Ransom · Accepted Answer · 2016-09-16 16:22:35Z

2

The decimal number used by Excel is simply the fraction of a day that a time represents, with midnight being 0.0. You simply take the hours, minutes, and seconds in the time and divide by the fraction of a day they represent:

def excel_time(time):
    return time.hour / 24.0 + time.minute / (24.0*60.0) + time.second / (24.0*60.0*60.0) + time.microsecond / (24.0*60.0*60.0*1000000.0)

answered Sep 16, 2016 at 16:22

Mark Ransom

310k44 gold badges423 silver badges660 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert a datetime.time type to float in python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related