public void ShouldReturnTimeFromStartTimeCellWhenPassedARequestedStartTime()
 {
     var startTime = new DateTime(2012, 12, 20, 08, 15, 00);
     using (var report = new XlsReport(TestTimesheet))
     {
         report.WriteStartTime(startTime);
         var readTime = report.ReadStartTime(new DateTime(2012, 12, 20));
         Assert.That(readTime, Is.EqualTo(startTime));
     }
 }
        public void ShouldWriteTimeToCorrectCellForMondayNextMonth()
        {
            using (var report = new XlsReport(TestTimesheet))
            {
                var nextMondayStartTime = new DateTime(2013, 01, 21, 08, 15, 00);
                report.WriteStartTime(nextMondayStartTime);
            }

            var date = GetValueFromCell(TestTimesheet, "February", "C7");
            Assert.That(ConvertToDateTime(date), Is.EqualTo(new TimeSpan(8, 15, 0)));
        }
        public void ShouldWriteTimeToCorrectCellForTuesdayStartTime()
        {
            using (var report = new XlsReport(TestTimesheet))
            {
                var tuesdayStartTime = new DateTime(2012, 12, 18, 08, 15, 00);
                report.WriteStartTime(tuesdayStartTime);
            }

            var date = GetValueFromCell(TestTimesheet, "January", "C8");
            Assert.That(ConvertToDateTime(date), Is.EqualTo(new TimeSpan(8, 15, 0)));
        }
        public void ShouldWritetimeToCorrectCellForTuesdayInCoupleOfWeeks()
        {
            using (var report = new XlsReport(TestTimesheet))
            {
                var nextMondayStartTime = new DateTime(2013, 01, 01, 08, 15, 00);
                report.WriteStartTime(nextMondayStartTime);
            }

            var date = GetValueFromCell(TestTimesheet, "January", "C40");
            Assert.That(ConvertToDateTime(date), Is.EqualTo(new TimeSpan(8, 15, 0)));
        }