Hi
Column F & G are date/time fields formatted as 3/14/12 1:30 PM . In Column H I want an if statement that says if the time portion of F or G is less than 7:00 AM bump the time up to 7:00 AM else let it be what it is
Example
F H
7/21/2020 7:39:09 AM 7/21/2020 7:39:09 AM H would remain as 7/21/2020 7:39:09 AM
7/22/2020 3:31:39 AM 7/22/2020 7:00:00 AM H would become 7/22/2020 7:00:00 AM
I was trying to use the Mod(F2,1) function If (Mod(f2,1) < 7:00:00 AM, int(f2) & 7:00:00 AM,F2) but it is obviously wrong
Thanks
Liz
Column F & G are date/time fields formatted as 3/14/12 1:30 PM . In Column H I want an if statement that says if the time portion of F or G is less than 7:00 AM bump the time up to 7:00 AM else let it be what it is
Example
F H
7/21/2020 7:39:09 AM 7/21/2020 7:39:09 AM H would remain as 7/21/2020 7:39:09 AM
7/22/2020 3:31:39 AM 7/22/2020 7:00:00 AM H would become 7/22/2020 7:00:00 AM
I was trying to use the Mod(F2,1) function If (Mod(f2,1) < 7:00:00 AM, int(f2) & 7:00:00 AM,F2) but it is obviously wrong
Thanks
Liz