CODEWITHSUNDEEP
exceltimenumbersdate-conversion
CrisH
CrisH

Reputation: 280

convert all dates in a column to numbers

I'm trying to convert time to numbers in excel. I am using this formula:

=HOUR(A2) + MINUTE(A2) / 60 + SECOND(A2) / 3600

And it works well, but I have to convert a column with around 65.000 of dates. How do I do that in an elegant and time saving way?

Upvotes: 1

Views: 112

Answers (2)

Rincewind
Rincewind

Reputation: 138

Assume you mean time rather than date. Try =A2*24 Format as general

To apply to a large range you can put 24 into a spare cell, copy it, select range you want to convert to number and paste special... Then select multiply and okay.

Upvotes: 0

Stergios
Stergios

Reputation: 3196

So assuming that your formula does what you want it to do, you just have to double click on the lower-right part on the cell with your first formula. So if your data are in the range A2:A65000, write your formula on cell B2, and double click on its lower-right part.

See the pic below:

enter image description here

Upvotes: 1

Related Questions