# 00:00:00 to 1899-12-30 bug with XLSX
**URL:** https://discourse.julialang.org/t/0000-to-1899-12-30-bug-with-xlsx/17224
**Category:** New to Julia
**Created:** [November 6, 2018, 9:22pm UTC](https://discourse.julialang.org/t/0000-to-1899-12-30-bug-with-xlsx/17224 "2018-11-06T21:22:07Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Errazuriz](https://discourse.julialang.org/u/Errazuriz)
#### Post date: [November 6, 2018, 9:22pm UTC](https://discourse.julialang.org/t/0000-to-1899-12-30-bug-with-xlsx/17224/1 "2018-11-06T21:22:07Z")
In my data set, I have a data type Time in 24-hour notation where midnight is written as 00:00:00. Then if I read the data with `XLSX.readdata()`, then 00:00:00 is converted to the date 1899-12-30.
For example, let’s say that we have an excel file (test.xlsx) with only one column such that:
| Time |
| --- |
| 23:58:00 |
| 23:59:00 |
| 00:00:00 |
| 00:01:00 |
If I extract the time from the excel files using `XLSX.readdata()`, I get the following :
```julia
julia> x = XLSX.readdata("test.xlsx", "Sheet1", "A2:A5")
4×1 Array{String,2}:
"23:58:00"
"23:59:00"
"1899-12-30"
"00:01:00"
```
I know that this bug is common with spreadsheets software data manipulations. Is there a fix to that bug? (Besides writing a function to filter the date.)
Thank you in advance.
---
### Author:  [@rdeits](https://discourse.julialang.org/u/rdeits)
#### Post date: [November 6, 2018, 9:50pm UTC](https://discourse.julialang.org/t/0000-to-1899-12-30-bug-with-xlsx/17224/2 "2018-11-06T21:50:32Z")
Since this is a problem with a specific library, you may have more luck if you open an issue for that particular library, presumably this one: [https://github.com/felipenoris/XLSX.jl/issues](https://github.com/felipenoris/XLSX.jl/issues)
---
### Author:  [@Errazuriz](https://discourse.julialang.org/u/Errazuriz)
#### Post date: [November 6, 2018, 10:03pm UTC](https://discourse.julialang.org/t/0000-to-1899-12-30-bug-with-xlsx/17224/3 "2018-11-06T22:03:34Z")
Thank you. You are right I am going to open an issue on git.