Posts by Xani

Re: Calculate time if greater than specific time in excel?

Why in the formula we put 4 ? Because I think I should put the value of 72:00:00 Hours to be as rule instead of number 4 which I don't understand what it represent.

=IF((K2-J2)>4,"Yes","")

Re: Calculate time if greater than specific time in excel?

Ok I will check it again, I tested it on one sheet but maybe your correct there is no time exceed 72 Hours.

Re: Calculate time if greater than specific time in excel?

I try it, it didn't work
I copy the formula into cell O2

Re: Calculate time if greater than specific time in excel?

Do you know a way to do it ?

Re: Calculate time if greater than specific time in excel?

I want to calculate how many times the duration exceed72:00:00 ?
If possible if the duration exceed it can be written “YES or“No” if no.

Re: Calculate time if greater than specific time in excel?

Dear AliGW,

Please find attached workbook.

Hello,

I would like to know how can I calculate if time in Duration cell is greater than 72:00:00 Hours ?

Please see below photo for your information.

Note: The formula I used for Duration is:

=TEXT(K2-J2,"hh:mm:ss")

Re: How to create a return button from one sheet to another ?

Dear royUK,

I will try to use the above solution in my exist excel sheet file.

Re: How to create a return button from one sheet to another ?

Dear dotchiejack,

I attached the photo but I don't know why it looks small!

Dear All,

I would like to create a button to go back from one sheet to another for example please see below photo:

I want to go back from IAB-SHIFT SHEET TO SUMMARY SHEET, After i press the button I receive the following error message:

[ATTACH=CONFIG]73203[/ATTACH]

I Use the following code:

Sub BackButton()
    Sheets("Summary").Select
    Range("A1").Activate
End Sub

After selecting the button and try to view the code I receive the following erorr message:

[ATTACH=CONFIG]73204[/ATTACH]