Formula

[Reza Dashti]

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


[TABLE="width: 877"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]No[/TD]
[TD]Enterance[/TD]
[TD]Exit[/TD]
[TD]Enterance Date[/TD]
[TD]Exit Date[/TD]
[TD]Enterance Time[/TD]
[TD]Exit Time[/TD]
[TD]Floating Delay[/TD]
[TD]Delay[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2019-01-04 8:18:00[/TD]
[TD]2019-01-04 16:13:00[/TD]
[TD]2019-01-04[/TD]
[TD]2019-01-04[/TD]
[TD]8:18:00[/TD]
[TD]16:13:00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2019-01-02 8:20:00[/TD]
[TD]2019-01-02 16:45:00[/TD]
[TD]2019-01-02[/TD]
[TD]2019-01-02[/TD]
[TD]8:20:00[/TD]
[TD]16:45:00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 8"]when "Enterance Time" is between 08:15 and 08:30, "Floating Delay" should display Enterance Time-08:15[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 8"]when I format date and time to display Persian date and time, formulas stop working with this format[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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