G
guyzdancin
I'm parsing a csv file that contains data in 15 minute intervals for a
day. The data is electricity consumption. The day is divided up into
segments of high, medium and low billing rates. For example, 00:00:00
to 10:45:00 is low rate, 11:00:00 to 18:45:00 is medium rate and
19:00:00 to 23:45:00 is high rate. I need a compare method so that I
can determine if any given time is greater or less than another.
Below is a sample of the file. The fourth field is time.
170,3EA,1041,18:00:00,.2847
170,3EA,1041,18:15:00,.2649
170,3EA,1041,18:30:00,.2486
170,3EA,1041,18:45:00,.3585
170,3EA,1041,19:00:00,.4179
170,3EA,1041,19:15:00,.4846
170,3EA,1041,19:30:00,.3480
170,3EA,1041,19:45:00,.2239
170,3EA,1041,20:00:00,.2600
170,3EA,1041,20:15:00,.2024
170,3EA,1041,20:30:00,.2126
170,3EA,1041,20:45:00,.3027
170,3EA,1041,21:00:00,.2882
170,3EA,1041,21:15:00,.2559
170,3EA,1041,21:30:00,.1392
170,3EA,1041,21:45:00,.1373
Thanks in advance
day. The data is electricity consumption. The day is divided up into
segments of high, medium and low billing rates. For example, 00:00:00
to 10:45:00 is low rate, 11:00:00 to 18:45:00 is medium rate and
19:00:00 to 23:45:00 is high rate. I need a compare method so that I
can determine if any given time is greater or less than another.
Below is a sample of the file. The fourth field is time.
170,3EA,1041,18:00:00,.2847
170,3EA,1041,18:15:00,.2649
170,3EA,1041,18:30:00,.2486
170,3EA,1041,18:45:00,.3585
170,3EA,1041,19:00:00,.4179
170,3EA,1041,19:15:00,.4846
170,3EA,1041,19:30:00,.3480
170,3EA,1041,19:45:00,.2239
170,3EA,1041,20:00:00,.2600
170,3EA,1041,20:15:00,.2024
170,3EA,1041,20:30:00,.2126
170,3EA,1041,20:45:00,.3027
170,3EA,1041,21:00:00,.2882
170,3EA,1041,21:15:00,.2559
170,3EA,1041,21:30:00,.1392
170,3EA,1041,21:45:00,.1373
Thanks in advance