I am trying to add a time to a date, to show me the day and the time as the answer, and this works well when it does not go over 24 hours into the next day (not sure I am actually expaining this very well)
eg on 5 November the end time is 15.17
I add this to 1 day, 6 hours and 58 minutes, giving me Tuesday at 22.15
I then add to this 1 day, 6 hours and 58 minutes, but it shows me Wednesday 05.13 instead of Thursday 05.13
The amount of time may change so I cannot add it by typing it in
I tried to say, if the time goes past midnight, add an extra day, but I cannot get this to work
I would really appreicate your help
[TABLE="width: 359"]
[tr][td][/td][td][/td][td][/td][td][/td][/tr][tr]
[TD="align: right"]00:09:17[/TD]
[TD="align: right"]05/11/2012[/TD]
Monday
[/td]
[TD="align: right"]15:17[/TD]
[TD="align: right"]01:06:58[/TD]
[TD="align: right"]06/11/2012[/TD]
Tuesday
[/td]
[TD="align: right"]22:15[/TD]
[TD="align: right"]01:06:58[/TD]
[TD="align: right"]07/11/2012[/TD]
Wednesday
[/td]
[TD="align: right"]05:13[/TD]
[TD="align: right"]01:07:25[/TD]
[TD="align: right"]09/11/2012[/TD]
Friday
[/td]
[TD="align: right"]12:39[/TD]
[/TABLE]
Thank you so much
Lynne