The data loggers which I use when doing building performance evaluations are great (Onset HOBO U12-012), but they have one little quirk that makes working with the data really irritating – dates come out in a variety of formats when imported into Excel.

It seems like it’s an actually an Excel problem. The data in the CSV file exported from the HoboWare software are stored in one format – 07/02/12 06:00:00 PM – but the data in Excel are sometimes translated into Excel serial dates (which is what we want) and sometimes remain in this Hobo format.

There may be a quicker way of handling this foible, but (as ever) my first thought was to throw some VBA at it. Here’s the code for a UDF which will knock that data into shape.

As ever, hope this helps someone else out.

Jamie Bull | jamiebull1@gmail.com

Related Posts

WiGLE is a popular platform which can be used for finding the location of a device using the names of WiFi networks in its vicinity. I’ve written about this before, and wrote some Python code to interact with their API. This API has since been retired and replaced with a new one, as of December […]

Just a quick post to point out a couple of really useful tools.The first is a web-based tool for finding weather files for a location of interest. It’s similar to the Excel EPW finder tool we created a few years back, but much more modern looking. It is however missing a few of the useful […]

Eppy is a really useful library which I’ve written about several times, since before I really had anything to offer in terms of contributing code. Over the past year or so though, I’ve started to contribute back some of the changes and additions I’ve made while using eppy on academic and commercial projects.This post is […]

1 Comment on “Convert HOBO U12 data logger dates to Excel serial dates”

Leave a Reply

Your email address will not be published. Required fields are marked *