stuck on date time addition

[oldbrewer]

[TABLE="width: 592"]
<colgroup><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]tom[/TD]
[TD="align: right"]05:55[/TD]
[TD="align: right"]01/08/2017 05:55[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]05:59[/TD]
[TD="align: right"]01/08/2017 05:59[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]01/08/2017 06:00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]jo[/TD]
[TD="align: right"]06:08[/TD]
[TD="align: right"]01/08/2017 06:08[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]08:00[/TD]
[TD="align: right"]01/08/2017 08:00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]08:05[/TD]
[TD="align: right"]01/08/2017 08:05[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]09:15[/TD]
[TD="align: right"]01/08/2017 09:15[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]09:20[/TD]
[TD="align: right"]01/08/2017 09:20[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]09:25[/TD]
[TD="align: right"]01/08/2017 09:25[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]09:30[/TD]
[TD="align: right"]01/08/2017 09:30[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]14:00[/TD]
[TD="align: right"]01/08/2017 14:00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]14:05[/TD]
[TD="align: right"]01/08/2017 14:05[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]14:06[/TD]
[TD="align: right"]01/08/2017 14:06[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]jo[/TD]
[TD="align: right"]14:07[/TD]
[TD="align: right"]01/08/2017 14:07[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]05:55[/TD]
[TD="align: right"]05/03/2135 05:55[/TD]
[TD]#####[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]05:59[/TD]
[TD="align: right"]05/03/2135 05:59[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]05/03/2135 06:00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]jo[/TD]
[TD="align: right"]06:08[/TD]
[TD="align: right"]05/03/2135 06:08[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]08:00[/TD]
[TD="align: right"]05/03/2135 08:00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]08:05[/TD]
[TD="align: right"]05/03/2135 08:05[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]09:15[/TD]
[TD="align: right"]05/03/2135 09:15[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]09:20[/TD]
[TD="align: right"]05/03/2135 09:20[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]09:25[/TD]
[TD="align: right"]05/03/2135 09:25[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]09:30[/TD]
[TD="align: right"]05/03/2135 09:30[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]14:00[/TD]
[TD="align: right"]05/03/2135 14:00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]14:05[/TD]
[TD="align: right"]05/03/2135 14:05[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]14:06[/TD]
[TD="align: right"]05/03/2135 14:06[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD]jo[/TD]
[TD="align: right"]14:07[/TD]
[TD="align: right"]05/03/2135 14:07[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]C column is F column + B column[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]why are rows 1 to 14 correct[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]and rows 15 to 28 not ?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]formula in marked cell is[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]=F15+B15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

only thing i'm thinking is there is a maximum [h] value which exceeds the 18 year offset, though i'm not sure i understand the problem > The maximum time value that you can type into a cell is 9999:59:59. If you type a value that is greater than or equal to 10,000 hours (10000:00:00), the time appears as a text string.

 

[oldbrewer]

I am adding 5 hours 55 minutes to 02/08/2017 00:00:01

 

[oldbrewer]

[TABLE="width: 1048"]
<colgroup><col><col><col><col span="2"><col><col span="3"><col><col span="2"></colgroup><tbody>[TR]
[TD]tom[/TD]
[TD="align: right"]05:55:00[/TD]
[TD="align: right"]01/08/2017 05:55[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD="align: right"]00:05:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]05:59:00[/TD]
[TD="align: right"]01/08/2017 05:59[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]06:00:00[/TD]
[TD="align: right"]01/08/2017 06:00[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD]day1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]jo[/TD]
[TD="align: right"]06:08:00[/TD]
[TD="align: right"]01/08/2017 06:08[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD]day2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]08:00:00[/TD]
[TD="align: right"]01/08/2017 08:00[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/08/2017 00:00:01[/TD]
[TD]day3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]08:05:00[/TD]
[TD="align: right"]01/08/2017 08:05[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/08/2017 00:00:01[/TD]
[TD]day4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]09:15:00[/TD]
[TD="align: right"]01/08/2017 09:15[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/08/2017 00:00:01[/TD]
[TD]day5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]09:20:00[/TD]
[TD="align: right"]01/08/2017 09:20[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]09:25:00[/TD]
[TD="align: right"]01/08/2017 09:25[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]09:30:00[/TD]
[TD="align: right"]01/08/2017 09:30[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]14:00:00[/TD]
[TD="align: right"]01/08/2017 14:00[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]14:05:00[/TD]
[TD="align: right"]01/08/2017 14:05[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]14:06:00[/TD]
[TD="align: right"]01/08/2017 14:06[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]jo[/TD]
[TD="align: right"]14:07:00[/TD]
[TD="align: right"]01/08/2017 14:07[/TD]
[TD]day1[/TD]
[TD][/TD]
[TD="align: right"]01/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]06:00:00[/TD]
[TD="align: right"]02/08/2017 06:00[/TD]
[TD]day2[/TD]
[TD]#####[/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]06:04:00[/TD]
[TD="align: right"]02/08/2017 06:04[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]06:05:00[/TD]
[TD="align: right"]02/08/2017 06:05[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]jo[/TD]
[TD="align: right"]06:13:00[/TD]
[TD="align: right"]02/08/2017 06:13[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]08:05:00[/TD]
[TD="align: right"]02/08/2017 08:05[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]08:10:00[/TD]
[TD="align: right"]02/08/2017 08:10[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]09:20:00[/TD]
[TD="align: right"]02/08/2017 09:20[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]09:25:00[/TD]
[TD="align: right"]02/08/2017 09:25[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]09:30:00[/TD]
[TD="align: right"]02/08/2017 09:30[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]09:35:00[/TD]
[TD="align: right"]02/08/2017 09:35[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]tom[/TD]
[TD="align: right"]14:05:00[/TD]
[TD="align: right"]02/08/2017 14:05[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sid[/TD]
[TD="align: right"]14:10:00[/TD]
[TD="align: right"]02/08/2017 14:10[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ann[/TD]
[TD="align: right"]14:11:00[/TD]
[TD="align: right"]02/08/2017 14:11[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]jo[/TD]
[TD="align: right"]14:12:00[/TD]
[TD="align: right"]02/08/2017 14:12[/TD]
[TD]day2[/TD]
[TD][/TD]
[TD="align: right"]02/08/2017 00:00:01[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]C column is F column + B column[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]why are rows 1 to 14 correct[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]and rows 15 to 28 not ?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]formula in marked cell is[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]=F15+B15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 4"]PROBLEM SOLVED TEMPORARILY BY COPYING[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]b1:b14 TO b15:B28[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"]THEN b15 REDEFINED AS B1+$H$1 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]where h1 is 5 minutes[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[MARK858]

I know you have found a tempory workaround but I am finding it difficult to work out what is the issue in your case because I get the correct results but if you format one of the 2/8/2017 cells in column F as a number (obviously with a copy of the data when you had the issue) what number does it return and are both columns C and F hard-typed or formulas?

Also is the data in columns C and F downloaded/imported rather than typed or formula results?

 

[oldbrewer]

Mark - I typed them in myself. The third column is just adding the date to the time to get a combined date_time. The problem is / was I think to do with the times. I retyped the marked cell to no avail but copying b1 to b15 solved it. I think best to move on.... thanks.