Formula

[Reza Dashti]

Hi
i have attached a workbook. I have two questions. If you open the workbook, you will see my problems.
thanks

No	Enterance	Exit	Enterance Date	Exit Date	Enterance Time	Exit Time	Floating Delay	Delay
	2019-01-04 8:18:00	2019-01-04 16:13:00	2019-01-04	2019-01-04	8:18:00	16:13:00
	2019-01-02 8:20:00	2019-01-02 16:45:00	2019-01-02	2019-01-02	8:20:00	16:45:00
	when "Enterance Time" is between 08:15 and 08:30, "Floating Delay" should display Enterance Time-08:15
	when I format date and time to display Persian date and time, formulas stop working with this format

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Special-K99]

Assuming column F is just a time and does NOT include the date

in H2 (Floating Time column)

=IF(AND(F2>="08:15:00",F2<="08:30:00","Enterance Time -08:15","")
copy down the column