I have a data set that is now in two columns.

One column denotes time.

The other column denotes a cost variable.

An example of 2 rows:

**Time..............................Cost**

Sept 8 2014 14:23:03....3.45

Sept 8 2014 14:04:45....6.01

…and so on (It literally looks like that, please ignore the dots)

What I want is for

__cost__to be

__summated__at

__regular time intervals__, whether daily, weekly or even hourly, (I need this for time series analysis (but don’t worry about that)). The number of costs varies per hour and per day so I imagine the way forward is a formula that can 'read' the info in the time column.

Guys, what is the most simple way of doing this?

Oh, and I'm using Excel for Mac, and I'm pretty new to the idea of macros!

*- Thanks in advance ! : )*

**M**