How to reference Time in a Date/Time Field

[Liz_I3]

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

 

[Eric W]

Try:

=INT(F2)+MAX("7:00"+0,MOD(F2,1))

 

[Joe4]

Try this formula, for an entry in row 2:

=IF(F2-INT(F2)>(7/24),F2,INT(F2)+(7/24))

 

[Liz_I3]

Thank you both they are both working. Thanks so very much

Liz

 

[Eric W]

Glad we could help. Thanks for the update.

 

[Liz_I3]

Thank you both they are both working. Thanks so very much

Liz