Hi all, I have a question, how do I change the Date & Time on each cell (on left side) to all have the same date but still the time not change, i just need the date change but not the time. Is there a function to detect DATE values & +/- depending its date value?
Date change.png
Yes. Something like this can be used:
=$F$1+MOD(A2,1)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
awesome, thanks!
you're welcome.
Hi Glenn, I still have a problem. I tried to COUNTIF search for specific time cells, but it has error, then I realized even if I manually type the Date & Time, the actual value is different from the MOD value. Is there a wayto make the MOD changes the DATE but follow the same time value?
Or is there another function that countif a time only by the hours & not minutes/seconds?
Time Value.png
These are rounding errors, caused by the way that Excel counts...
see the yellow shaded cells...
that works. again much appreciated!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks