Date Time Change by Formula

[@tul]

Hi All,

want to change date for call if coming after 7 pm.

Date New Date
2/2/2017 21:44 2/3/2017 10:00 Call coming after 7 pm need to change next day date

 

[jayalaxmi]

Hi All,

want to change date for call if coming after 7 pm.

Date New Date
2/2/2017 21:44 2/3/2017 10:00 Call coming after 7 pm need to change next day date

Hi Atul

Good eve

Please find attached see if it helps you.

Thanks & Regards
Jaya

 

[pecoflyer]

Or in one go =IF(MOD(H2;1)>19/24;H2+1;H2)

 

[@tul]

Or in one go =IF(MOD(H2;1)>19/24;H2+1;H2)

Hi,

Thanks for taking concern.

Its help but need date along with time at morning 10:00 Am.
Plz help me out.

Actual Date 2/2/2017 21:44
By Formula 2/3/2017 21:44
Required 2/3/2017 10:00

 

[bosco_yip]

Hi,

Thanks for taking concern.

Its help but need date along with time at morning 10:00 Am.
Plz help me out.

Actual Date 2/2/2017 21:44
By Formula 2/3/2017 21:44
Required 2/3/2017 10:00

Try,

=IF(MOD(H2,1)>19/24,INT(H2)+1 10/24,H2)

or,

=IF(MOD(H2,1)>19/24,INT(H2)+1.41666666666667,H2)

Regards

 

[@tul]

Hi Atul

Good eve

Please find attached see if it helps you.

Thanks & Regards
Jaya

Hi,

thanks for concern.

Actually I need Date along with Time

Try,

=IF(MOD(H2,1)>19/24,INT(H2)+1 10/24,H2)

or,

=IF(MOD(H2,1)>19/24,INT(H2)+1.41666666666667,H2)

Regards

Thanks, its work.