Identify time elapsed after each hour

Is there a formula that I could use to identify the time elapsed after the hour?

End result I am trying to achieve is;

Student A;
Due in: 09:00:00
Arrived: 09:06:51
Result = "Late"

Student B;
Due in: 08:00:00
Arrived: 07:58:13
Result: "Ok"

Originally Posted by Aardigspook

If all you want is 'OK' or 'Late' then, assuming that row 1 is a header row and that Due in' is in A2 and 'Arrived' in B2, use this:

Formula:

Please Login or Register  to view this content.

If you want the elapsed time as well, try this:

Formula:

Please Login or Register  to view this content.

I should made it clear, I have attached what I am trying to create; Lateness is anything over 1 minutes

Timelog:
This will have log in times dumped in from system report containing username and time logged in

Track:
This will have username and the weekdays with Vlookup if username is in timelog array then "In" otherwise "Update" (update meaning check and manually update) -- Ideally, I would like to nest the time formula here and identify lateness here

Lateness:
Same template as Track as I wasn't able to nest in the lookup formula for lateness. This would be used for "late" otherwise "ok"

Each student would arrive at different times during the morning, some 8:00:00, some 09:00:00, some 10:00:00 etc and with just their First Login time available, makes it difficult for me....

How do we know if they are late if we don't know expected (required) arrival time: this latter time does not appear in your supplied data?

Originally Posted by MarvinP

Hi many,

See if the attached with a simple If statement does what you want.

Attachment 504304

Sorry, "Due in" was more figurative. I would only have their "Arrive" time - see attatchment

The only way I can recognize Lateness is anything > 1 minute past the hour. EG- 08:01:58 = Late

Originally Posted by JohnTopley

How do we know if they are late if we don't know expected (required) arrival time: this latter time does not appear in your supplied data?

Sorry, "Due in" was more figurative. I would only have their "Arrive" time - see attachment above

The only way I can recognize Lateness is anything > 1 minute past the hour. EG- 08:01:58 = Late

So "Adam Wiiliams" is nearly 30 minutes late (not early for 13:30 start?).

Originally Posted by JohnTopley

So "Adam Wiiliams" is nearly 30 minutes late (not early for 13:30 start?).

That's Correct! Anything past the hours, over 1 minute is late.

Actually, To identify early starters, no is able to log in until 15 minutes to the hour EG- 08:45 for 09:00 starters etc, but 08:32 would be late

It's very tricky with these conditions

Actually, so not to over complicate things, anything past the hour mark more than a minute would be late