Excel Date Calculation Function

[Thasthahir]

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

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

 

[njimack]

Why does your 3rd row return "Time Crossed" rather than 04:00:00?

Based on your description, try his:

=IF(HOUR(B2)<22,TIME(22,0,0)-B2,"Time Crossed")