Excel Date Calculation Function

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

Time+8 HoursRemaining time
13:05:2021:05:2000:54:40
15:00:0023:00:00Time Crossed
10:00:0018:00:00Time Crossed
12:00:0020:00:0002:00:00

<tbody>
</tbody>

Regards,
Mohideen Thasthahir
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
Why does your 3rd row return "Time Crossed" rather than 04:00:00?

Based on your description, try his:
Code:
=IF(HOUR(B2)<22,TIME(22,0,0)-B2,"Time Crossed")
 

Watch MrExcel Video

Forum statistics

Threads
1,108,510
Messages
5,523,318
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top