Reza Dashti
New Member
- Joined
- Jan 4, 2019
- Messages
- 1
Hi
i have attached a workbook. I have two questions. If you open the workbook, you will see my problems.
thanks
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
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>