Apr 25 2019 05:44 AM
In one column i have a start time (11:00) and in another an end time (18:00).
Can I make Excel understand that a person is on place at 16:59?
My potential end result is maybe to create a form. Where I want to search for a person on a given place on a given time.
Apr 25 2019 05:49 AM
@Anders402659 , yes time in Excel is actually decimal number. You may check as with any other number, for example
=IF( (myTime> = startTime)*(myTime <= endTime), "here", "not here")
Apr 25 2019 06:47 AM
Thank you that helped. Now I have to hink further....on the next step