Thasthahir
New Member
- Joined
- Mar 6, 2018
- Messages
- 9
Hi There,
I have Some times ("hh:mm:ss") format in A column. In B column Have added a formula. It means i have added 8 hours based on A column data. B Column Formula : (=A2+time(8,0,0)).
Requirement:
A column time will not cross after 8 hours. If it will cross After * hours Column should be update Time Crossed commend.
IF not C column will show remaining time compare to current Time.
If current system time 22:00:00
<tbody>
</tbody>
Regards,
Mohideen Thasthahir
I have Some times ("hh:mm:ss") format in A column. In B column Have added a formula. It means i have added 8 hours based on A column data. B Column Formula : (=A2+time(8,0,0)).
Requirement:
A column time will not cross after 8 hours. If it will cross After * hours Column should be update Time Crossed commend.
IF not C column will show remaining time compare to current Time.
If current system time 22:00:00
Time | +8 Hours | Remaining time |
13:05:20 | 21:05:20 | 00:54:40 |
15:00:00 | 23:00:00 | Time Crossed |
10:00:00 | 18:00:00 | Time Crossed |
12:00:00 | 20:00:00 | 02:00:00 |
<tbody>
</tbody>
Regards,
Mohideen Thasthahir