Add 1 hour to Timestamp with if statement

[asolopreneur]

I want to add 7 hours to timestamp if time is 01:00:00AM and add 1 hour if it's not 01:00:00AM.

I tried - if(A2=TIMEVALUE("01:00:00AM"),A2+TIME(7,0,0),A2+TIME(1,0,0)) A2 = <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>08/Jan/19 8:0:0AM

1 hour is getting added but it's not adding 7 hours if there is "01:00:00AM".

Here is my Google Sheet - https://docs.google.com/spreadsheets/d/1DkmsjUQXAurZfIxLbEq7nCaL07ubouxzjFFKFyrf0f0/

Thanks in advance

 

[gaz_chops]

Try

=IF(ROUND(MOD(A2,1),5)=0.04167,A2+TIME(7,0,0),A2+TIME(1,0,0))

 

[Phuoc]

Or try this:

=A2+IF(TEXT(A2,"hmmss")="10000",7/24,1/24)

 

[asolopreneur]

It's working, awesome.

Thanks for taking time and helping me out. Could you please tell me how it works in brief?

Thanks again, cheers!

 

[asolopreneur]

It's working, awesome.

Thanks for taking time and helping me out. Could you please tell me how it works in brief?

Thanks again, cheers!

Or try this:

=A2+IF(TEXT(A2,"hmmss")="10000",7/24,1/24)