Try
=B2-1/3 formatted as date, or
=INT(B2-1/3) if you don't want the time portion
Try
=B2-1/3 formatted as date, or
=INT(B2-1/3) if you don't want the time portion
So i have the date and time stamps in column C... need the results as in Column B ( i have manually entered it now).. change in date required refer to Row 8
1 18/06/2018 16/06/2018 16:15
2 18/06/2018 17/06/2018 16:30
3 18/06/2018 18/06/2018 16:45
4 18/06/2018 19/06/2018 17:00
5 18/06/2018 19/06/2018 17:15
6 18/06/2018 19/06/2018 17:30
7 18/06/2018 19/06/2018 17:45
8 19/06/2018 19/06/2018 18:00
9 19/06/2018 19/06/2018 18:30
10 19/06/2018 19/06/2018 18:45
11 19/06/2018 19/06/2018 19:00
12 19/06/2018 19/06/2018 19:15
13 19/06/2018 19/06/2018 19:30
14 19/06/2018 19/06/2018 19:45
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks