Time Comparison

[otixz]

Good day,

I have a program that calculates log in and out of an employee...

My question is how can I make a function that would test if the time entered by the employee is valid

example:

1.) IN : 02:00:00 OUT: 03:00:00 Result: VALID
1.) IN : 22:00:00 OUT: 01:00:00 Result: VALID
1.) IN : 23:00:00 OUT: 22:00:00 Result: INVALID
1.) IN : 02:00:00 OUT: 01:00:00 Result: INVALID
1.) IN : 02:00:00 OUT: 00:00:00 Result: INVALID

Thank you very much.

[Piranha]

What kind of field do you use to store the times? I would use datetime, then just check

if ($out < $in)
{
    invalid
}
else
{
    valid
}

[bradgrafelman]

If you can't do the calcuations in a database, this might work:

list($hour_in,$min_in,$sec_in) = explode(':', $time_in);
list($hour_out,$min_out,$sec_out) = explode(':', $time_out);
$valid = TRUE;

if($hour_in > $hour_out)
    $valid = FALSE;
elseif($hour_in == $hour_out)
    if($min_in > $min_out)
        $valid = FALSE;
    elseif($min_in == $min_out)
        if($sec_in >= $sec_out) // >= because if they are equal, times are the same
            $valid = FALSE;