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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

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,113,908
Messages
5,544,989
Members
410,647
Latest member
LegenDSlayeR
Top