Using IF to compare time values
Solved/Closed
keh_2878
Posts
2
Registration date
Sunday December 8, 2019
Status
Member
Last seen
December 9, 2019
-
Dec 8, 2019 at 06:21 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Dec 10, 2019 at 11:51 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Dec 10, 2019 at 11:51 AM
Related:
- Using IF to compare time values
- Popcorn time - Download - Movies, series and TV
- Ocarina of time rom - Download - Action and adventure
- Time set day - Guide
- How to change time in whatsapp - Guide
- Time of day clock stopped - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Dec 9, 2019 at 12:09 PM
Dec 9, 2019 at 12:09 PM
Hi Keh,
It works for me, at least after matching your query with the formula:
=IF(B1>SUM(A1+TIMEVALUE("00:00:01")),1,"")
Comparing column A to B and leaving the cell blank, when condition is not met.
Does it work now?
Best regards,
Trowa
It works for me, at least after matching your query with the formula:
=IF(B1>SUM(A1+TIMEVALUE("00:00:01")),1,"")
Comparing column A to B and leaving the cell blank, when condition is not met.
Does it work now?
Best regards,
Trowa
Dec 9, 2019 at 03:44 PM
Dec 10, 2019 at 11:51 AM