Hello,
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
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