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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

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,112,817
Messages
5,542,670
Members
410,567
Latest member
SCraig123
Top