How to Find which one is greater between 2 times

**anto1510** · 12-05-2010, 04:48 AM

Hi All,
I am trying to use If condition to find which one is the max time however i am not able to do it.Below is the example

"Login Time
IST" Actual Login Time Discrepancy
23:45 23:53
18:15 18:35
18:15 18:13
19:15 19:14
18:15 18:15

In discrepancy i need to check if actual login time is more time than login time IST then it should subtract actual login time from login time IST or else it should display login time IST .

Note: Actual Login Time is in Time format.

**DonkeyOte** · 12-05-2010, 05:18 AM

What happens when the times cross midnight - eg "IST" 23:55 and "Actual" 0:30 ?

I suspect you will need to build in some logic to differentiate the above from the likes of example 3, ie:

Please Login or Register  to view this content.

in the above we calculate the time difference where either Actual exceeds IST or where the hour differences would imply a midnight cross over
(in the latter case the Actual Time precedes the IST Time despite being "greater" in reality)

**anto1510** · 12-05-2010, 05:41 AM

What if the actual login time is in date and time format (12/2/2010 8:00) ?

**DonkeyOte** · 12-05-2010, 05:55 AM

If that's the case it's simply

Please Login or Register  to view this content.

Dates and Times in Excel are just numbers.
Dates being Serial Numbers and Time being decimal (1 equating to 24 hours)
It is the Date Format applied to those Numbers that generates the Date "strings" as you see them - if you format as General you will see the underlying numeric.

**anto1510** · 12-05-2010, 06:07 AM

what i actually meant is explained with below example

"Login Time
IST" Actual Login Time
23:45 12/2/10 11:53 PM

your forluma is not working with the above example