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
A B C D E
<tbody>
</tbody>
Note: In D column Timer will be show the time if 8 hours is not crossed. If 8 hours crossed it will be show " Time Crossed"
Regards,
Mohideen Thasthahir
<tbody>
</tbody>
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
A B C D E
Time | +8 Hours | System Current time | Remaining time | Remaining time | |
13:05:20 | 21:05:20 | =Now() (Time Format) | =C1-BB | ||
15:00:00 | 23:00:00 | =Now() (Time Format) | =C2-B2 | ||
12:00:00 | 20:00:00 | =Now() (Time Format) | =C3-B3 |
<tbody>
</tbody>
Note: In D column Timer will be show the time if 8 hours is not crossed. If 8 hours crossed it will be show " Time Crossed"
Regards,
Mohideen Thasthahir
<tbody>
</tbody>