Thanks! Just the solution I was looking for! Leigh Ann
"N Harkawat" wrote:
=if(A1-INT(A1)=(1/24*7),a1+1,a1)
and format it as date
"Leigh Ann" wrote in message
...
I have a time and date field such as "5/25/05 13:05." I need a calculation
so that if the time is greater than or equal to 7:00, then it should
return
the same date. If it is after 7:00, it should return the next day's date.
Thanks - Leigh Ann
|