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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]+8 Hours[/TD]
[TD]Remaining time[/TD]
[/TR]
[TR]
[TD]13:05:20[/TD]
[TD]21:05:20[/TD]
[TD]00:54:40[/TD]
[/TR]
[TR]
[TD]15:00:00[/TD]
[TD]23:00:00[/TD]
[TD]Time Crossed[/TD]
[/TR]
[TR]
[TD]10:00:00[/TD]
[TD]18:00:00[/TD]
[TD]Time Crossed[/TD]
[/TR]
[TR]
[TD]12:00:00[/TD]
[TD]20:00:00[/TD]
[TD]02:00:00[/TD]
[/TR]
</tbody>[/TABLE]

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")